Are you good at OBIEE Dashboard Building?

The art of writing superb analyses and building popular interactive dashboards is not something that we see much of in the OBIEE blogsphere.  Sure we have to build fast databases, and configure the servers, but what the customer sees is the dashboard.

I will look a bit harder this week for front end tips, so please get yours published on the groups, blogs and tweets.

I am actually trying to hire a couple of dedicated dashboard developers, so please take a look at the jobs page to see if you are what I am looking for.

rssBlogs of the week

Have a look at our blogger database. Not listed? Contact us to be added on.

1. How to update report and automatically store updated by and updated time through writeback in OBIEE

Bojie says, “Today I am going to talk about writeback in OBIEE. As you know, writeback is a feature in OBIEE that allows users to update reports that they see in OBIEE without having to deal with the ETL process and reloading table.”

Read more here.

2. Installation check “diskspace” failed…..

John Booth says, “We’re working with a client on an upgrade where Essbase and Essbase Studio are on a Red Hat 5.6 Linux box.”

He then goes through a diskspace error and the solution!

3. Oracle EPM 11.1.2.4 – What’s Coming – The Rumor Mill

Eric Helmer goes through the rumours for:

  • The Big Bullet Points for 11.1.2.4
  • HFM
  • FDMEE
  • Financial Reports
  • Disclosure Management
  • OFMA
  • Planning
  • HPCM
  • Oracle Cloud
  • Data Relationship Management
  • Essbase

4. Calculation Manager, BSO Planning, and ASO Planning combine for an awesome ASO Essbase procedural calculation hack — Part 1

Cameron Lackpour introduces the first part of a three part blog post on how to achieve awesomeness in ASO Planning and beyond.  In Part 1 he gives an introduction to the CDFs you most likely don’t know about.

To come are:

Part 2 – The genius of Joe Watkins

Part 3 – Tying it all together across three different Oracle EPM products with of course a glorious hack.

Keep reading!

5. How to unlock the locked table in Oracle

Kashinathan talks us through how to unlock it!

6. OBIEE Substitute a Filter Variable

Gerd says, “In ISO calendar the week turns on Mondays. When not reporting on real-time data and having a one day load frequency you will see no results each Monday. So it would be best to see previous week data on Mondays and of course having not change the filter criteria in the report.”

He then talks us through how to do this.

7. OBIEE BUNDLE PATCH 11.1.1.7.140715 AKA 11.1.1.7.8 (?) is available

The patch is available for:

  • HP-UX Itanium
  • IBM AIX on POWER Systems (64-bit)
  • Linux x86
  • Linux x86-64
  • MS Windows (32-bit)
  • MS Windows (64-bit)
  • Oracle Solaris on SPARC (64-bit)
  • Oracle Solaris on x86-64 (64-bit)

8. Sorting Control on Grand Total in Pivot Table – OBIEE 11g

Praveen says, “Unfortunately, OBIEE doesn’t have a sort Control on the Grand Total and, creating a column with a total doesn’t get me what I have required. It has ends up being another metric in the pivot.”

For that we need add another metric name which Praveen shows us how to achieve.

9. OBIA 7.9.6.3 Pre-requisites, System Configuration, Performance improvements (Server Side & Development Side), Query Performance Tuning, Maximum connections

This blog goes through the:

  • OBIA Pre-requisites
  • System Configuration
  • Performance improvements (Server Side)
  • BI APPS Performance Tuning (Development Side)
  • Query Performance Tuning
  • Maximum connections

10. OBIEE 11.1.1.7 Port conflict

Anjum Ara blogs about Error message : INST-08010: Error in validing the port range for auto port allocation. At Least 2 ports should be free within the range 7500-7500 for the Adminserver and Adminserver SSL

He goes through the reason and the solution

11. Five Reasons to Attend Oracle OpenWorld (Part Two)

In part two of this post, Meghan Fritz gives the final two reasons to attend!! They are:

Reason #2: Get a vision of Oracle’s future. Hear all about Oracle’s roadmap straight from the source.

Reason #1: Fill in the blanks… fast. Expand your knowledge and get the answers you want and need. All in just five days. 

twitter logo

This week on Twitter

Abhinav Agarwal shared ORACLE BIG DATA APPLIANCE X4-2

OraNA.info tweeted Oracle Big Data SQL – Bringing Structured Queries to an Unstructured World

Bernard Marr posted Facebook And Big Data (No, Big Brother?)

Follow Addidici on twitter for daily OBIEE news and updates.

linkedin logoThis week on LinkedIn

Daisy Ding shared How to Process Text Files in the Data Analytics

Ian Bristow posted OBIEE Version 11.1.1.7.140715

Jordi Gonzalez shared Oracle In-Memory Higlights including “Oracle Database In-Memory: Powering the Real-Time Enterprise”

Join the Oracle Business Intelligence LinkedIn group for the latest OBIEE discussions, news and updates.

paperli

Paper.li

This week’s OBIEE News – Edition of 14th July

Stories from blog.3sixty-analytics.com and  thatjeffsmith.com

Videos such as:

The 11.1.1.8 Oracle WebCenter Content User Interface

and Larry Ellison: “throw a switch and everything runs faster”

 

OBIEE Jobs Market Powers Ahead

 

The OBIEE jobs market seems to have heated up again, if my missed calls list is anything to go by!

Check out the 522 jobs on Indeed.co.uk

http://www.indeed.co.uk/jobs?q=obiee&l=UK

Paper.li

This week’s OBIEE News – Edition of 7th July

Stories from mandsconsulting.com and thatjeffsmith.com

Videos such as:

Real Time BI with Kevin & Stewart: Unnecessarily Censored

blog

Blogs of the week

Have a look at our blogger database. Not listed? Contact us to be added on.

1. Introducing Checkmate - True Development Lifecycle For OBIEE

Kevin and Stewart discuss how the development lifecycle is hard in OBIEE. This rarely surfaces in the first implementation, but frustratingly creeps-in over time.  However, this blog posts introduces a solution – Checkmate! Read the blog post for full details.

2. Lookup in ODI 11g

This post goes through the two steps:

Step 1: Creating target table

Step 2: Creating INTERFACE

3. Planning – setting the cell retrieval threshold and interesting hack

John Goodwin begins by saying: “If you have been working with planning then no doubt you have experienced the web application JVM crashing at some point which can be caused by a number of different factors.”

Read his extensive blog on this here.

4. OBIEE Patch 11.1.1.7.140527 now available

Paul Cannon informs us, “Oracle have just released the next patch set for OBIEE allowing any 11.1.1.7.0 installation to be upgraded to version 11.1.1.7.140527.” He says there are no new features in this patch – it’s just a bug fix patch and the list of bugs fixed is rather long !!

5. The Efficient Analyst (part four): The over-processing epidemic

In Part four, Jeff Quigley states that over processing can take different forms including:

  • Intermediate files or sheets are created to “stage” data.
  • Multiple human beings need to touch or analyze the data
  • Legacy spreadsheets that are complicated and intertwined

He then goes on to advise us to ‘Streamline our Workflow’. 

6. OBIEE – Comparing performance to peers

Boris Dahav was asked about an analysis where he compares the list of top 10 products of a company with the top 10 off all the others. This blog posts describes the solution and in the next post he will give some ideas of how this could be done better.

7. Five Reasons to Attend Oracle OpenWorld

It gives us some good reasons to attend Oracle OpenWorld including:

Reason #5: Leave your heart. Because you WILL leave your heart in one of the world’s top tourist destinations.

Reason #4: Test-drive the latest. You’ll have the chance to demo the latest technology and experience all of Oracle’s innovations in one place.

Reason #3: Shake hands with your worldwide community. With countless networking opportunities, you’ll get to share thoughts and hear success stories…. all in person

But we have to read the next blog for the top 2 reasons!!

8. 3 More Oracle SQL Developer Bloggers

Jeff Smith gives us the names of 3 more developers who blog: Kris Rice, Barry McGillin and Vadim Tropashko.

Check them out!

linkedin logoThis week on LinkedIn

Join the Oracle Business Intelligence LinkedIn group for the latest OBIEE discussions, news and updates.

Kashinathan K posted  Splunk Overview for Operational Intelligence and Log Management

Daisy Ding shared The Case to Illustrate Parallel Computing of Big Text File

Jagadeesha R shared a problem he was having when exporting to Excel.  Help him out here.

twitter logo

This week on Twitter

ODTUG shared Danny Byrant’s lookback at KScope14

Gerd Aiglstorfer tweeted OBIEE Variable LOGLEVEL and Report Based Logging

KPI Partners asked Why Integrate OBIEE, Essbase, and Hyperion?

Follow Addidici on twitter for daily OBIEE news and updates.

Kscope 14 Special

paperliPaper.li

This week’s OBIEE News – Edition of 30th June

Stories from: mandsconsulting.com and videos such as:

KScope 2014 Preview: Stewart Bryson on OBIEE, ODI

blog

Blogs of the week

They went, they heard, they blogged about it:

1. KScope14 (Sunday) – APEX Symposium – before noon

Dimitri Gielis blogs about the APEX symposium on the Sunday of Kscope.

2. Red Pill Analytics at Kscope ‘14: Symposiums, Sessions, Panels, Deep-Dives, Oh My!

Kevin McGinley and Stewart Bryson run through the Kscope plans for this year.

3. Cameron Lackpour shares photo and news from each day of Kscope 14.

Kscope14 Day 0  

Kscope14 Day 1

Kscope14 Day 2

Kscope14 Day 3

Kscope14 Days 4 and 5

4. Falling in Seattle aka “Dusting off this blog thing”

John Booth talks about his 3 hours in hospital after falling off a Seattle sidewalk, BI on the Cloud, Oracle Data Integrator and Infrastructure Deep Dive!

5. Vlamis Repeating ODTUG KScope Presentations

Vlamis repeated their Kscope presentations as Webcasts so people could share them with their colleagues.

And in other blogs this week…

1. Importing Data from SQL databases into Hadoop with Sqoop and Oracle Data Integrator (ODI)

Benjamin Perez-Goytia goes through:

  • Importing Data from SQL databases into Hadoop with Sqoop and Oracle Data Integrator (ODI)
  • ODI 12.1.3 Application Adapters for Hadoop
  • About the Knowledge Modules in this Article
  • IKM SQL to HDFS File (Sqoop)
  • IKM SQL to HDFS Hive (Sqoop)
  • Knowledge Modules Tasks
  • Knowledge Modules Options
  • Benefits of Using Sqoop with Oracle Data Integrator (ODI)

and much more in this extensive blog post.

2. Introducing Checkmate: True Development Lifecycle For OBIEE

Red Pill Analytics introduce Checkmate, True Development Lifecycle For OBIEE in this blog post.

twitter logoThis week on Twitter

Kevin McGinley shared Real time BI live from Kscope

Debra Lilley posted KSCOPE14 – Awesome, Selfies, Brambles & The Cure for Low Technology

Kent Graziano shared Kscope14: A lookback

ODTUG shared THANK YOU FOR ATTENDING KSCOPE14

linkedin logo

This week on LinkedIn

Monica Hasebi posted Kscope 14 highlights video

also:

Gerd Aiglstorfer posted OBIEE Fine Colouring

Daisy Ding shared How to import Excel Data into Access database for more efficient statistical analytics

On the Ferry to France

paperliOBIEE News is out! Edition of 23rd June

Stories from: artofbi.comkentgraziano.com and siebel-essentials.com

Videos such as:

Edward Roske of InterRel talks about Oracle HPCM at MD Anderson Cancer Center at Collaborate 2014

and Oracle Database 12c: Introduction to a Multitenant Environment with Tom Kyte

I am off to the European championships, so will unfortunately miss Kscope14.  Maybe next year…

blogBlogs of the week

Have a look at our blogger database. Not listed? Contact us to be added on.

1. Trying to understand the Oracle Reference Architecture for Information Management

Daan Bakboord refers to a presentation by Andrew Bond and Stewart Bryson at the Rittman Mead Forum last month.  The presentation about Oracle Information Management Reference Architecture caused some further investigation on his part. This blog post is a first summary of the information he found online so far.

2. Oracle BI Mobile App Designer Release 2

Alex Hansal took the new BIMAD for a test drive then blogged about it! He finishes his post by saying, “As fellow blogger Christian Screen put it eloquently: “BI got MAD and you should be happy.” The latest release of BIMAD provides a welcome round of enhancements and new features. So don’t get MAD, get BIMAD ;-) .”

3. Exploring OBIEE Collaborative BI – Webinar – June 20, 2014 (2pm EST)

Christian Screen says, “If you’ve thought about commenting on OBIEE dashboards or believe that users need a way to tell the story about their data, you are not alone. We’re putting on the first webinar discussing Collaborative BI in Oracle Business Intelligence this Friday June 20th at 2pm EST. We’d like you to sign up for the webinar and attend here,
http://bit.ly/1ou9ti3

4. A very helpful OBIEE Cache Purge/Seed utility – download it for free here!!!

Shiva Molabanti  has made a tool and is making it available for free! He says, “This is completely free for you for the benefit of OBIEE Community…. Using this, you can simply Purge or seed the OBIEE Server Cache remotely. Yes, you don’t need to login to OBIEE server or Application. You can simply do that from your own system. ”

5. The Efficient Analyst (part three): No more waiting

In part 3 of this series, Jeff Quigley reviews the causes of analyst wait time and offers suggestions on how to fix it.

6. Sunday! Sunday! Sunday! Symposiums at the smokin’ ODTUG Kscope14

Cameron Lackpour says, “If you are at ODTUG Kscope14, I daresay you’ll be at the Sunday Symposiums, where we get to hear, direct from Oracle, where the products we use are going.  If the past is prologue to the future, I can say that what gets announced on Sunday is the early jump on what Oracle will be announcing at Oracle Open World. That’s pretty cool – Oracle use Kscope as the preview venue, not their own conference.  We are insanely lucky.”

7. New Oracle EPM Infographic…

Eric Helmer shares an infographic from here:

epm infograph

8. OBIEE – Problem with changing default port to 80 on Windows

Boris Dahav briefly describes the process of changing OBIEE default port and talks about a specific problem he had with port 80 on Windows (and how to solve it.)

linkedin logoThis week on LinkedIn

Daisy Ding added Functions of esProc/R/Python/Perl in Structured Data Process by Comparison :Chapter 5. Obtaining Field Value

Ian Bristow shared RDA 8.04 has been Released

Shiva Molabanti posted A very helpful OBIEE Cache Purge/Seed utility – download it for free here!!!

Join the Oracle Business Intelligence LinkedIn group for the latest OBIEE discussions, news and updates.

twitter logoThis week on Twitter

Daan Bakboord shared A very helpful OBIEE Cache Purge/Seed utility – download it for free here!!!

ClearPeaks tweeted Oracle Business Intelligence Enterprise Edition Samples

OTNArchBeat posted This month: Tech Summit, WebLogic, Identity Manager, ADF Mobile

which includes links to White Papers, Webcasts, Audio and Video such as:

Follow Addidici on twitter for daily OBIEE news and updates.

Happy Birthday to Me!

Thank you all for your kind birthday wishes.

 

Here is how I mixed business with Birthday….

 

This is the only Pie chart I would use…

 

pie-i-have-eaten

Sir Ben Ainslie Challenges Oracle

America’s Cup: Sir Ben Ainslie announces British bid

Olympic Gold medalist Sir Ben Ainslie was joined by the Duchess of Cambridge as he launched Britain’s bid to win the 35th America’s Cup. Sir Ben says, “We can bring America’s Cup back to Great Britain!

http://youtu.be/YwwZBxm3QwM

 

140610_Ben-Ainslie-Racing_070-616x616

OBIEE News is out! Edition of 9th June

Stories from:blog.3sixty-analytics.com, mkashu.blogspot.com and artofbi.com

Videos such as: Business Objects to OBIEE

and Oracle Enterprise Manager 12c: Using Agent-Side Compliance Rules

rssBlogs of the week (and other news)

Have a look at our blogger database. Not listed? Contact us to be added on.

1. It’s The End Of The Blog As We Know It (And I Feel Fine)

Kevin McGinley writes his last blog post on Oracle Analytics, due to him starting a new company with Stewart Bryson (Red Pill Analytics).  Well done and Congratulations! Any future blog posts from Kevin will be posted here.

2. Introducing Red Pill Analytics

Kevin McGinley and Stewart Bryson announce the launch of Red Pill Analytics, a new analytics services company focused on Oracle business intelligence and data integration solutions. Take a read here for more information.

Stewart says, “We think we have a compelling story to tell… a story about real innovation and services that deliver value above all else. This story needed a metaphor… one that embodies the choice we all have when confronted with brand new approaches in the marketplace. In the end, we couldn’t find a better metaphor than the Red Pill from The Matrix.”

3. OUGF Harmony 2014, #OUGF14

Kent says, “Several highlights for me were meeting and speaking with one of the pioneers of relational theory, CJ Date, and getting to see my good friend Dan Linstedt in action talking about Big Data and Data Vault 2.0.”

He then links to HelifromFinland’s post.

4. Deep Dive Thursday at Kscope14

Cameron Lackpour continues with the highlights of KScope – looking forward to what is to come on the ‘Deep Dive Thursday’. There are NINE different Deep Dives happening at the same time.

1.Application Express

2. ADF and fusion Development

3. Developer’s Toolkit and the Database

4. Business Intelligence

5. Essbase

6. Planning

7. Financial Close

8. EPM Foundations

9. Reporting

He ends this blog by saying, “As always, Kscope suffers from too much good content all at the same time.  What a conference, what a problem to have. Thursday’s Deep Dives continue that tradition and I know you will all be there for what promises to be a very interesting and innovative series of events.  If I wasn’t moderating, I would be flitting from room to room, trying to get all of the geeky wisdom I could into my brain.  You might just be able to do that.”

5. OBIEE Mobile App Designer Release 2

Gerd informs us that Release 2 of OBIEE Mobile App Designer with synonym 11.1.1.7.10-BIMAD-PS1 is now available for download.

He says the new features for the new release are:

  • User interface is redesigned
  • New map component
  • New page type “Exploration Page”
  • Creating of global filters
  • Adding calculated fields
  • Filter component renamed “List”
  • Defaults and multiselect is now supported
  • Adding custom components to your apps

Read more here.

6. Solving OBIEE Issues

Gerd refers back to a previous post, OBIEE Client Success and Typical Issues and says, “There are just ten working days left until planned application launch – that’s a challenge that we accept with pleasure! We recommended the following steps:

  • Create a logical OBIEE model using the current data warehouse objects.
  • Only substitute data warehouse tables if absolutely necessary.
  • Identify and define an optimized target model balancing OBIEE and data warehouse.
  • Implement interim solutions if necessary to succeed on upcoming milestone.
  • Plan, design and implement a state of the art OBIEE solution after first rollout.”

7. OUG Finland (Harmony) 2014

Brendan blogs about the local Tar ice-cream, the conference, camping and meeting Chris Date.

He concludes, “This was a great conference that had attendees (not just speakers) from a number of countries across Europe. I enjoyed the conference and getting to meet some old and new friends. Hopefully next year I will be able to fit OUG Finland into my calendar and so should you.”

linkedin logoThis week on LinkedIn

Daisy Ding shared Chapter 1.Retrieving Table from Database, Chapter2. Import from Text to 2D Table and  Chapter3.Import 2D table from Excel.

Kent Graziano posted OUGF Harmony 2014, #OUGF14

Gerd Aiglstorfer shared Solving OBIEE Issues

Join the Oracle Business Intelligence LinkedIn group for the latest OBIEE discussions, news and updates.

twitter logoThis week on Twitter

Kevin McGinley tweeted Red Pill Analytics with Four Sessions Selected for Oracle OpenWorld

Oracle Analytics posted What Oracle’s Intelligence Guy has to say on The Single Source of Truth

Corporate Technologies shared 2 Challenges of Converting Legacy Reporting Into OBIEE

Follow Addidici on twitter for daily OBIEE news and updates.

Summertime, and the OBIEE is easy

paperli

Paper.li

OBIEE News is out! Edition of 2nd June

Stories from artofbi.com, thatjeffsmith.com and
@KPIPartners

Videos such as: What is Oracle Enterprise Repository (OER)

and Glenn Hoormann of Ludus talks to us about Oracle Business Intelligence and ERP at Collaborate 2014

rss

Blogs of the week

Have a look at our blogger database. Not listed? Contact us to be added on.

1. Planning 11.1.2.3.500 and Smart View

John Goodwin says that he was going to write this blog when PSU 11.1.2.3.500 was released but totally forgot. However, recently he has heard about this issue a couple of times so thought he might as well post it in case it happens to anybody else.

He concludes his post, “So the simple solution is if patching planning to 11.1.2.3.500 then make sure you are on Smart View 11.1.2.5.200+ which should be easy to implement if you have a small user community though more of a challenge if you have a large user base which deploys Smart View by package management.”

2. BI Apps 11.1.1.8.1Configuration Manager freezing

Paul Cannon says, “After installing BI Apps 11.1.1.8.1 I had an issue with the Application Configuration Manager application freezing. I was able to setup Load Plans, start generations and executions, but often when refreshing the page to see the current status the browser would just hang and eventually time out.”

He then gives us the code to fix this problem.

3. The Efficient Analyst (part one): Stop moving your data around!

Jeff Quigley goes through five ways to reduce data movement and put the focus back on sharing:

1. Stop emailing (IMing, Skyping) files back and forth

2. Eliminate “staging” files or sheets

3. Be careful with “movement automation”.

4. Create a sharing environment.

5. Google it

He says that the suggestions in this post are most effective when moving data between individuals using the same application.  He asks for readers to post suggestion to solve data sharing across applications.

4. Main Features of Teradata Database

Kashinathan goes through the features of Teradata , saying it is easy to administer, acts as a single data store and users include Walmart and AT&T.

5. About merging 2rpd in OBIEE – the only article that matters.

Bojie says that the confusing part is, how to determine original master rpd, Modified rpd, Current Rpd. He then goes through what he does to remember. He tells us to note that the merging of rpds can take a while. If one of the RPD is 20MB, the whole merging process can take up to 3 hours!

6. The sessions I want to attend at Kscope14

Cameron Lackpour is splitting this blog post into three as there is just so much to write!

  • This week – individual sessions
  • Next week – Thursday Deep Dives
  • Week of 15 June – Sunday Symposiums

Read this blog to find out which individual sessions he is hoping to attend.

7. Easy to develop and debug

Raqsoft BI OLAP says, “The step-by-step computing of esProc makes it easier to monitor the intermediate result, and debug the code. The development efficiency of esProc is therefore enhanced greatly.”

linkedin logoThis week on LinkedIn

Michael Rainey  posted GoldenGate and Oracle Data Integrator – A Perfect Match in 12c… Part 2: Journalizing Knowledge Module

Daisy Ding shared Relational Queries by Reference: Generic Data, Sequence, and Table Sequence

Daniel Fore posted Discoverer Conversion

Join the Oracle Business Intelligence LinkedIn group for the latest OBIEE discussions, news and updates.

twitter logoThis week on Twitter

OracleBlogs tweeted OBIEE 11.1.1 – Tips for In-place Upgrade from 11.1.1.6 to 11.1.1.7.x

KPI Partners shared Business Objects to Oracle BI Conversions

Cezar Baisanu posted Business Intelligence: How does Tableau stackup against OBIEE?

Follow Addidici on twitter for daily OBIEE news and updates.