Monthly Archives: December 2014

The Best of 2014

Well. This is it, the end of another great OBIEE year, and what a year of blogging it was.

I tried to find a top 10 blogs for 2014 but when I got to 22 blogs to choose from I decided to cover them all!

Happy New Year.

What will 2015 bring?

1. How-To: File hunt for OBIEE GUI changes

Christian Berg says that one of the questions that frequently comes up is ‘How do I change a part of the GUI of OBIEE?’

He says the point isn’t simply to say “do X in Y”, but rather “how do you get to know that you need to change X in Y?

He then talks us through the process.

2. RittmanMead BI Forum 2014 – Wrap – up

Daan Bakboord summarises the RittmanMead BI Forum. He says that the program is varied with Oracle BI EE, Oracle Endeca, Aggregation Persistence, Big Data, Oracle Exalytics, Oracle BI Cloud,  Oracle Information Management Reference Architecture etc. It was also a place to network and exchange ideas.

He also praised Robin Moffat for his presentation, ‘No Silver Bullets – OBIEE Performance in the Real World’.

[slideshare id=34476471&doc=rittmanmeadbiforum2014nosilverbullets-obieeperformanceintherealworld-140509053752-phpapp01]

3. Minimalist Design for the Criteria Tab

Jeff McQuigg says, “When it comes to OBI report design, minimalist is the only way to go when it comes to the Criteria Tab. Whereas architecture and design are subjective, when it comes to keeping the criteria tab minimalist there is a strong, demonstrable benefit to this philosophy. It’s so important that this is the very first thing I look for when I am called in for a performance healthcheck review.”

This post takes a quick look into why.

4. 3rd-Party Visualizations in OBIEE

Kevin McGinley writes:

“In Part 1 of this post, I wrote about why you might want to add third-party visualization capabilities for OBIEE and gave a brief explanation how to setup one approach: calling java visualization engines. In Part 2 I walked through a detailed example of how to actually do this using a visualization engine called Flot. In this post I will do the same thing for a visualization engine called D3.”

5. Cloud Services Are Reaching Maturity – Thoughts from OOW 2014

Myles Gilsenan writes of how he attended Oracle OpenWorld (OOW) 2014 recently with a focus on BI, Big Data and ERP.

He then summarises:

Business Intelligence (BI)

  • BI Cloud Services
  • BI Apps (ODI version)
  • Golden Gate and Real Time Reporting
  • OBIEE/Essbase Integration

Enterprise Performance Management (EPM)

  • Budgeting and Planning Cloud Service
  • Big Data  – Big Data Discovery, SQL for Big Data, Big Data Appliance
  • Enterprise Resource Planning
  • Oracle Fusion Apps
  • Fusion Financials & Oracle Transactional BI
  • Oracle Functional Set-Up Manager (FSM)

6. Oracle BI Mobile App Designer – Version 2

Peak Indicators discuss Version 2 with the new features:

  • Map Visualisation
  • Custom Maps
  • Set of new functions with redesigned calculated fields

and improved functionality on:

  • Redesigned authoring UI
  • Exploration template
  • Application level calculated fields
  • Filters

They then go through in detail:

  • User Interface
  • Calculated Field
  • Multiple Filters
  • Exploration Page
  • Sidebar
  • New Map Visualisation
  • New Custom Map
  • Plugins
  • Other Features

7. MS Sharepoint and Oracle APEX integration

Dimitri Gielis says that at Oracle Open World, he gave a presentation about the integration of Microsoft Sharepoint and Oracle Application Express (APEX).

View his slideshow:

[slideshare id=40350847&doc=dgielis-141016082317-conversion-gate01]

8. Oracle ACE Program: Follow Up

Tim Hall shares more thoughts on the Oracle ACE Program including the ‘Access to Information’ and  ‘Access to Support’.  Take a read.

9. APEX 5.0 – Keyboard shortcuts

Dimitri Gielis lists the the keyboard shortcuts in Oracle Application Express (APEX)

10. 6 Desktop BI Tools

  1. Excel
  2. R Project
  3. ES Series
  4. SPSS
  5. STATA

11. My OOW14 Overview

Debra Lilley gives us her OOW14 overview including linking to her video

“2 Minute Tech Tip: Communication Between Technical and Business Stakeholders”

12. Collaborative BI ZigZag – BIWisdom Response

Christian Screen writes, “When I speak to people about the idea of collaboration in Business Intelligence, it usually begins by me explaining that in its simplest form Collaborative BI is the ability to comment or annotate a report or a dashboard in a BI System.”

He then goes on to explain ‘Collaborative BI’ further.

13. Purging corrupted OBIEE web catalog users

Christian Berg says, “NOTE: This is a quick & dirty solution!”

14. Global Currencies in Oracle BIA

Daan Bakboord writes, “If you read the Oracle Documentation for Oracle BIA (, you could find the following; “Currency conversions are required because your business might have transactions involving multiple currencies. To create a meaningful report, you have to use a common currency.”

15. OBIEE11g: Creating and Developing Custom Styles, Skins & Messages (Part 2)

Andrew Fagence writes, “In my previous article (found here: I explained how to develop and deploy a custom skin within OBIEE. In this part of the article I will explain how to develop and deploy a custom style and message.”

16. Your OBIEE Commentary and Collaboration Issues are a Thing of the Past…

Justin Townsend writes about commentary and collaboration problems being a thing of the past…

17. Oracle BI 11g – Adding a dynamic logo and title to your dashboard page

Leigh Wilson says, “This post is a long overdue upgrade from my 10g Dynamic Banner post.

Most of my stakeholders don’t like the visual noise that dominates a typical Oracle BI project.
I usually take control of the look and feel by hiding away the banner and “branding” my Oracle BI projects using a logo.

This post will help you take control of the look & feel. It also forms the basis for other advanced dashboarding posts in my blog.”

18. How to Use Strategic Planning and KPIs to Achieve Business Success

Steve Yeung summarises:

  • Define the Vision and Core Values of the Company
  • State Your Primary Mission
  • Set Corporate and Departmental Goals
  • Do a Situation Analysis
  • Set Out Your Business Plan
  • Set up Key Performance Indicators
  • Conclusion

19.  Introducing Checkmate – True Development Lifecycle For OBIEE

Kevin McGinley says,

In his opinion, every development environment should have the following:

  • A working area for each developer
  • Source control for everyone developing
  • Branch-based development, with automatic merging of selected features into a fully-functional release
  • Automatic regression testing of each and every new feature as part of the development process, before migration to QA
  • Environment-specific build processes that automatically generate and deploy artifacts to each environment

20. Treemap Visual Now Available on Oracle BI Cloud Edition

Christian Screen writes, “We all like new shiny-spoon features and it looks like the Oracle BI public cloud edition will be brandishing at least one new visual on which we can feast our eyes. Treemap visualizations have long been a staple in analytical visual renderings and many a business user will be happy to explore this new functionality.”

21. Who moved my data?

John Booth writes a homage to ‘Who moved my cheese’!

22. Build Your Own Time Hierarchy

Jeff McQuigg covers:

  • There Are Multiple Hierarchies to be Aware of
  • A Closer Look at a Level
  • Optional Columns
  • Column Naming
  • Putting the Table Design Together
  • OBI Configuration
  • Building Calendar Data
  • Testing
  • Other Notes

And wraps up by saying, “A good time hierarchy should be very robust and flexible for users. We really shouldn’t ever need to build special RPD or report logic to concatenate or do funky things with the calendar dimension – build them into the table. Hopefully you’ve seen how easy it actually is, and adding a new column isn’t that daunting.”



OBIEE Weekly Roundup

This week I have updated the Blogger database, adding more members and putting links in place  to the ACE Directory and oracle community.


Also this week I heard from ODTUG that my submission to talk at next years conference in Miami was not successful, but I think I will go anyway.  I need to figure why they didn’t want to hear about advanced OBIEE techniques.  I am hoping its because my submission was not eye catching enough, and not that OBIEE is not a popular subject any more?  Lets wait see what come out on the agenda at KSCOPE 16


Blogs of the week

Is your blog listed on our blogger database?

1. Preparing for TOGAF 9 and ArchiMate 2 Exams

Daan Bakboord shares two presentations that he made to help him study for these exams.

2. What is a data scientist?

Jeremiah Johnson defines data scientists as  ‘master communicators’. He looks at:

  • The Core Skills
  • What they bring to the table
  • What they do
  • Bottom Line

3. Catching Up on Mobile

Carlos Chang helps us to catch up on Oracle Mobile Application Framework (MAF)

  • There’s a new version of Oracle MAF
  • Oracle Enterprise Pack for Eclipse (OEPE)
  • The Mobile Application Framework Challenge
  • Mobile Design Patterns

4.  How do you tell a ‘good’ story based upon data?

Dan Power’s tips include

  • Keep in mind what’s interesting to your audience.
  • Come up with your ending before you figure out your middle.
  • “Putting it on paper lets you start fixing it. If it stays in your head, a perfect idea, you’ll never share it with anyone.”

5. File Encoding in the Next Generation Outline Extractor

Tim Tow writes, “We had a couple of issues reported with the output of the Next Generation Outline Extractor where the exported file did not work properly as a load file.” Read the blog to find out the solution

6. Easy method to create BIP 11g reports on top of OBIEE dashboards.

Vishal Pathak talks us through a quick way of producing BIP reports on top of OBIEE dashboards.

linkedin logoThis week on LinkedIn

Join the LinkedIn group for discussions, news and the latest blog posts.

Gerd Aiglstorfer posted Criteria for OBIEE project success

Uday Singh shared What is relational algebra?

 asks How to embed a Google Docs spreadsheet with OBIEE? Read the answers and join in the discussion.


twitterThis week on Twitter

Follow Addidici on Twitter

KPI Partners tweeted OBIEE Mobile Application Designer: Features, Issues, Limitations

Robin Moffatt shared No Silver Bullets – OBIEE Performance in the Real World

Boris Dahav posted Simple OMM4OBI use cases with OBIEE



Stories from and

Videos such as

OVUM talks about making the business case for Oracle Enterprise Performance Management


Excluding and Including Columns Without Editing a Fusion OTBI Report