Monthly Archives: March 2014



This week’s OBIEE News is out! Edition of 24th March

Stories from, and

Videos such as:

The Intelligence Guy – Oracle BI Mobile

blogBlogs of the Week

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

1. EPM patch has landed

John Goodwin says, “Finally after a long wait EPM has arrived and the patch comes in a bundled 1.8GB download or as Oracle likes to call it a superpatch.”

Read the full details here.

2. OBIEE BI Publisher prompts not visible when added to dashboard page

Arun Kumar writes, “When creating a BI Publisher report from a BIP data model, we can add prompts on the report directly to have interactivity on the report. This is specifically useful if you end up creating a BIP report when all required field are not available in the Subject Area, and the report is more like a one-of report (not requiring any further Ad-Hoc analysis). The report and prompts work well when accessed from a catalog directly. But when you try to add the same BIP report to a dashboard page, it does not show the prompts for some reason.”

He then explores in his post, two workarounds for this problem.

3. OBI Mobile App for Android devices available now

Download it from the Play Store.

Shiva Molabanti gives us some useful screenshots as a taster!

4. OBIEE 11g – Multiple Instances on Computer – Auto Ports Vs Custom Ports

Pravin Khadakkar states, “The standard installation of OBIEE 11g would configure software components to default ports. These ports may be different if it is chosen manually during installation process. The problem arises when company plans to install multiple instances of Oracle Business Intelligence on a single computer; there is a need to decide on a port management strategy. There are two options; the first option is to allow Oracle Business Intelligence 11g Installer to assign the ports for each instance automatically while other option is to assign ports through a custom port configuration file (.ini).”

He then goes through:

  • Auto Port
  • Custom Port Configuration
  • Review Configuration
  • Commands to Find Active Ports

5. Live from the 1st Annual World Wide Data Vault Consortium: Day 1

In the 1st of three posts, Kent Graziano gives us the news from Day 1 of the 1st Annual World Wide Data Vault Consortium.

6. Live from the 1st Annual World Wide Data Vault Consortium: Day 2

Read on for the highlights of Day 2.

7. Live from the 1st Annual World Wide Data Vault Consortium: Day 3

…and finally the news from day 3!

8. Open World 2014 – guidelines for call-for-papers…

Keith Laker provides us with his top 10 list of guidelines for submitting proposals including:

* Make the title and abstract interesting – Your title and abstract must be easy to read and make sure you introduce your main idea as early as possible. Review the titles and abstracts from previous conferences as a guide. Ideally make the issue relevant to the delegates attending OWW, get to the point, and make sure it is easy to read.

* Look at previous presentations – the content catalog for last year’s conference is available online,see here: You can review all the titles and abstracts that were accepted and use them as guidelines for creating your own title and abstract for this year’s conference.

Read the full article for more fantastic tips.

9. Creating Text Entry in Essbase – SmartList

Steve Yeung explores SmartLists in this blog. He concludes with, “The interesting part is that OBIEE doesn’t seem to support SmartList for some reason. Let me see what I can do to retrieve this list later on next week.”

10. Oracle BigDataLite version 2.5.1 is now available

Brendan Tierney tells us of that a new updated versions of the BigDataLite VM was released on Wednesday.

The following components are included on Oracle Big Data Lite Virtual Machine v 2.5:

Oracle Enterprise Linux 6.4

Oracle Database 12c Release 1 Enterprise Edition (

Cloudera’s Distribution including Apache Hadoop (CDH4.6)

Cloudera Manager 4.8.2

Cloudera Enterprise Technology, including:

Cloudera RTQ (Impala 1.2.3)

Cloudera RTS (Search 1.2)

Oracle Big Data Connectors 2.5

Oracle SQL Connector for HDFS 2.3.0

Oracle Loader for Hadoop 2.3.1

Oracle Data Integrator 11g

Oracle R Advanced Analytics for Hadoop 2.3.1

Oracle XQuery for Hadoop 2.4.0

Oracle NoSQL Database Enterprise Edition 12cR1 (2.1.54)

Oracle JDeveloper 11g

Oracle SQL Developer 4.0

Oracle Data Integrator 12cR1/

Oracle R Distribution 3.0.1

It can be downloaded from here.

twitter logo

This week on Twitter

Alexander Hansal tweeted Time to Learn the Languages of the Web (and Good Design) and Oracle announces Java 8

John de Voogd shared Six Challenges of Big Data

Blake Ramsey tweeted The Bold Data Project: Big Data and the Tailored Fit

Oracle Blogs posted OBIEE:Difference between High Availability and Scale Out

OTNArchBeat shared OBIEE Security Examined: WebLogic Security

Follow Addidici on twitter for daily OBIEE news and updates.

linkedin logoThis week on LinkedIn

posted “Oracle SOA” online DEMO Session Scheduled on Saturday, 29 March at 8:00 AM IST.

Kent Graziano shared Live from the 1st Annual World Wide Data Vault Consortium: Day 2 and  Live from the 1st Annual World Wide Data Vault Consortium: Day 3

Paul Anderson posted Patch Release: Hyperion Essbase PSU

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

Another Awesome OBIEE Week

paperliOBIEE News is out

Read this week’s – Edition of 17th March

Stories from, and

Videos such as: Nurturing Innovation with Oracle Business Analytics

rssBlogs of the week

1. Purging corrupted OBIEE web catalog users

This blog by Christian Berg says, “Sometimes it can happen that user profiles within a web catalog become corrupted for any number of reasons. In order for these user profiles to be correctly re-initialized, there’s more to be done than just drop /users/JohnDoe from the web catalog.

All in all there are three distinct places which need to be cleaned:

  • /users/JohnDoe
  • /system/users/123456
  • /system/acocuntids/987654″

He then goes on to explain how to do this.

He asks us to note that this is a quick & dirty solution and he hasn’t fool-proofed it with any check like “does the folder exist” etc. so use it cautiously and at your own risk!!

2. 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.”

Oracle BIA stores amounts in the following currencies;

– Document Currency –> Currency of the actual Transaction (Can vary in a multinational organization)
– Local Currency –> Currency defined in the Ledger
– Global Currency –> Defined in the DAC

You can use a Global Currency if you want to report all the different Currencies in one Global Currency (eg. ‘EUR’, or ‘USD’). Oracle BIA for Oracle eBS is able to report in 3 different Global Currencies. If you use Oracle BIA for CRM, you are able to store an additional two Global Currencies. You define the Global Currencies in the DAC.”

Read on for further details.

3. New Features in Oracle Fusion/Cloud Applications Release 8

Alexander Hansal writes, “As announced a few days ago, Oracle has published a new release of its Fusion Applications (ERP, HCM, CRM) product line, namely Release 8.”

Alexander gives his personal list of highlights as:

  • New Skyros Theme
  • Redesigned Global Header
  • User Interface Text Editor
  • Application Composer

4. Finding Calculated View Columns

Jeff Smith says, “Imagine you have 300 or so views, and within those views, are a bunch of business rules. Like, we’re going to calculate someone’s salary as their salary + their (commission percent * sales). Now imagine your views, and their columns, aren’t documented. They’re not documented in the data model, and they’re not documented via the column comments. Now imagine someone is asking you for a full accounting of these so they CAN be documented.”

Jeff then goes on to give us a solution to this.

5. OBIEE 11g – How to Add New Fonts in Answers and Dashboards

This blog by Pravin Khadakkar is an attempt to share information he recently came across regarding adding new fonts in Answers and Dashboards.

He goes through processes for ‘Add New Font’ and ‘Add Font in Schema for Validation.’

6. Performance testing of Hive, Impala and esProc Part 2

In the previous article, they tested the grouping computing. In this article, they test their performances and compare their results in associating computing.

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

twitter logoThis week on Twitter

John de Voogd tweeted Big Data Drives The Smart Car – InformationWeek

Cezar Baisanu posted Simple workflow implementation in APEX

Alexander Hansal shared Oracle reverses decline in hardware revenue during Q3

Follow Addidici on twitter for daily OBIEE news and updates.

linkedin logoThis week on LinkedIn

Raqsoft OLAP posted Performance Comparison Testing of Hive, esProc, and Impala Part 1

Simon Berglund  shared Commonwealth Bank hopes business app will win new customers

Paul Anderson  posted Important! Discoverer Statement of Direction

Divyesh Dave PMP shared What Are The Differences Between SQL Analytical Functions rank, dense_rank and row_number?

Come and join in our group discussions on LinkedIn.  There are over 8,000 members conversing  about OBIEE news and updates.

Better Late Than Never

This week’s OBIEE News.  Edition of 10th March

Stories from, and

Videos such as: Hackers are Reputation Thieves

and Creating a Studio chart using data from multiple views

blogBlogs of the week

Are you featured in our Blogger Database? If not, please contact us in order to be listed.

1. Important! Discoverer Statement of Direction

Product Management have released the Statement of Direction for Oracle Business Intelligence Discoverer Tools.  This document is available to download from My Oracle Support. It contains vital information about:

  • Oracle’s Product Strategy
  • Oracle’s Support Policy
  • Oracle’s Recommendations to Customers

2. ODM: Changing the bar chart format in Explore Node

This blog by Brendan Tierney says, “In Oracle Data Miner you can use the Explore Node to gather an initial set of statistics for your dataset. As part of this you will also get a bar chart that shows the distributions of the values contained within each attribute.”

He says that the default bar chart is a little basic and he then goes through the steps in order to change the bar chart to 3D.

3. OBIEE FusionCharts Part4 – FusionCharts Configuration

Steve Yeung has previously covered in this series:

Part 1 – Installation

Part 2 – Data Integration

Part 3 – Advanced Integration

In this 4th blog of the series, he goes through setting border, fonts, background and colours.

4. OBIA 7964 – Multiple Calendar Support Configurations In Five Easy Steps

Pravin Khadakkar goes through a scenario where the customer is implementing BI Apps 7964 based on E-Business source system. The source system has been configured for two sets of business lines within a flagship company. One is retail while other one is around oil, which is very valid business scenario in modern businesses. The retail and oil business have different ledgers with different type of calendars.

He says, “this blog is an attempt to showcase the configuration which I have done to achieve multiple calendar implementations within single business analytics warehouse.”

He looks at Calendar Formats, Calendar Categories and Calendar Configuration.

5. OBIEE 11g: Creating and Developing Custom Styles, Skins & Messages (Part 1)

Andrew Fagence says, “Within OBIEE 11g, it is possible to highly customise the appearance and the ‘look and feel’. This is because the UI (User Interface) within OBIEE 11g is compiled and generated from a script which can be edited. There are 3 main components which controls the appearance of the UI which are Styles, Skins and Messages.”

He then explores the difference between the three components. He goes on to explain how to modify and deploy custom skins. In the second part of the article,he says that he will explain how to deploy and configure custom styles and messages.

6. On-Demand: Why Integrate OBIEE, Essbase, and Hyperion?

This recording from KPI Partners covers:

  • Part 1 – What is all this stuff? (OBIEE, Essbase, Hyperion)
  • Part 2 – Differences Between BI & EPM
  • Part 3 – Why Integrate BI & EPM?
  • Part 4 – Integration Success Stories
  • Part 5 – OBIEE/Essbase Integration Demo
  • Part 6 – Q&A Session

7. Does your DBA hate you? 5 Tips for writing efficient SQL queries that get you some DBA love.

This blog by SQLdepbeta  says, “I spoke with my DBA friend today who runs an Oracle data-warehouse that’s about 2 terabytes big, at an international bank. I asked him: “What are some typical problems that users, data analysts, and DB developers have, that make you want to pull your hair out?”

They say that in his friend’s experience, the vast majority of performance problems fall into the following categories:

1) Don’t call a function or use expressions on an indexed column
2) Analyze the tables you create
3) Break down your work into bite-sized SQL steps
4) Use Distinct only when needed
5) Create indexes

They conclude:

“Database Admins, developers, data analysts, and other users are all part of the same team. As with nearly every other situation in life, patience, communication, and education are often the keys to working together smoothly to achieve common goals.”

8. Oracle BIA – Making the Full / Incremental Load work

Daan Bakboord says it is possible to configure either a Full- or an Incremental Load in Oracle BIA. He says that first you start with the Informatica Mapping. He tells us exactly how to do it here.

9. Bridging the Old BI World with Big Data Analytics

This article by Alex Woodie says, “We’re in the middle of a revolution in data analytics, where old beliefs and approaches are being discarded as new technologies emerge.”

Read on…

10. Evaluating BI Tools: Compare OBIEE with Open Source reporting tools

After exploring the comparisons, this post concludes by saying, “There is no perfect tool, it’s up to the individuals, from company visionaries to architects, from engineers and project managers to make things work perfectly. But knowing the limitation of each tools, I hope it can drive future improvement of these technologies, but more importantly, help the decision makers to make the right decision from the beginning.”

11. Learn a lot about Oracle BI

Daan Bakboord encourages us to educate ourselves, network and immerse ourselves in some real problems.  He also recommends viewing the Addidici blogger database for some superb reading material.

twitter logoThis week on Twitter

Bernard Marr tweeted Big Data: The One Strategy Missing In Most Companies

Cezar Baisanu shared Big Data vs. the Data Warehouse

John de Voogd posted A Brief History of Big Data, Analytics and Small Data tweeted ORA-13504

Follow Addidici on twitter for daily OBIEE news and updates.

linkedin logoThis week on LinkedIn

Paul Anderson shared RDA Version 8.03 Released

David Booth posted Determining data lineage: SQL scripts vs documentation

shared Download the free webinar on collaborative business intelligence

Alex Anvari asked In your organization, how do you find innovative ways to leverage your Enterprise Data?

Join the LinkedIn group for daily OBIEE discussions, news and updates.

National Jeff Day


This week’s blog is dedicated to Jeff McQuigg, Senior Architect at KPI Partners

A little bit about Jeff:

  • He developed many of Siebel’s early Analytics v7.0 best practices & wrote part of the certification exam.
  • He has personally been involved with over 35+ OBI projects in every capacity (BI Architect, Data Modeling, RPD Metadata, Business Analyst, Report Developer, ETL Architect/Developer, Project Manager, Pre-Sales).
  • He is a BI & OBI Thought Leader:
  • Jeff frequently is an Oracle Open World Speaker.
  • He has developed OBI Deployment Methodology, deliverable templates and all Training programs with Metricsphere.

Some of his best blogs:

1. The Single Most Important Thing to Know About the OBI RPD

This blog from September 2013 states that Dimensional Hierarchies in OBIEE are used for a variety of important features. This post explores the fundamental reason for their existence and some specialized features that require their existence.  But mostly he discusses the single most important thing to know about the RPD!

2. Making Dims & Facts Work Together

Jeff says in this blog from June that this is a very common RPD modeling question on IT Toolbox. The problem is stated something like this:

“I have 2 fact tables and 3 dimension tables.  One of the dimension tables doesn’t work with Fact #2 while the other 2 dimension tables work with both facts.  When I make a report with all 3 dimensions and both facts, Fact #2 is incorrect or missing.”

He then restates the problem using ‘good BI language.’ The blog post also features slides from a recent presentation of his.

3. Bad BI Form

This blog from October 2013 was featured as one of our ‘Blogs of the Weeks‘. In this blog post, Jeff demonstrates visually how circles can not be compared easily but in a vertical bar, comparison is visually better. He says to keep this in mind when dealing with comparisons using area based visuals.


4. Hanging In The OPN Lounge With Norm Dy & Jeff McQuigg

This blog from November 2013 features the following video:

5. HR Analytics at Wells Fargo – Project that won KPI Partners the Specialized Partner of the Year Award for BI and EPM

In this September 2013 blog, Jeff announces that the project he bled and sweated over for nearly a whole year won KPI Partners the coveted Oracle Excellence Award for North American Specialized Partner of the Year in BI & EPM (formerly know as the Titan Award). He has also written a presentation that goes into further detail about the project.

He goes through the following areas of the project:

  • Enterprise BI
  • Prototype-to-Production
  • Technical Solution for making multiple hierarchies end user friendly, all folded in with advanced data security
  • Performance


6. Keep It Simple Stupid

This blog from December 2012 was another to be referred to in one of our weekly blog posts.

Jeff says, “I’ve been spending a lot of time recently working on performance tuning projects.  Sometimes the BI apps are slow, sometimes it’s custom, sometimes it’s a mix.  I’ve gotten the chance to see what works in both Oracle and SQL Server. My conclusion about both of these databases is that they are like a cat or dog that gets fooled when you play hide the ball; they aren’t very smart sometimes.  The only way you can really truly ensure database engines, even modern advanced ones, do things the right way to is to make it as simple and easy for them to understand as possible.”

He covers this in the following way:

  • Star Schema not Snowflake
  • Map straight to fields
  • Use Good Date Joins
  • Outer Joins Should Be Outta Here

Papers and Presentations

Planning for High Performance OBI

This presentation from September 2010 has the following agenda:

  • Introduction
  • Logical Data Architecture
  • Physical Data Model
  • Physical Database
  • Oracle Focused
  • Physical Database
  • Oracle Focused
  • OBI Server
  • User Interface
Another presentation from September 2010, with the following agenda:
  • Introduction
  • Business Need & Solution
  • Technical Solution
  • Project Implementation
  • Agenda
  • Status & Future Plans
  • Challenges, Lessons Learned & Best Practices
  • Wrap-Up
From June 2011, this was the agenda:
  • Introduction
  • Physical Data Model
  • Physical Database –Oracle Focused
  • OBI Server
  • User Interface

Advanced MetaData Topics

This paper is from the Rittman Mead BI Forum in Atlanta, May, 2011. The agenda is:
  • Combo Tables
  • Make Dims & Facts Reach
  • Non-Conformed Dimensions
  • Canonical Time
  • Selecting a Logical Table Source
  • Controlling Join Paths

HR Analytics at Wells Fargo Bank

This is downloadable from the above link as a pdf.  It discusses the project that won the 2013 Excellence award for KPI Partners.  It covers:
  • Business Need & Solution
  • Project Implementation
  • Status & Future Plans
  • The Solution & Key Aspects
  • Data Model and ETL Efforts
  • Challenges, Best Practices & Keys to Success

Build a Performance Layer for Oracle Business Intelligence Applications 11g

This is described as:

“All the best work on your Oracle Business Intelligence Enterprise Edition–based system will be wasted if users are frustrated with long response times for dashboards and reports. Learn from an Oracle ACE with more than 10 years of implementation experience what contributes to poor performance and what the best solutions are to improve the end user experience and user adoption. This session discusses the creation of a performance layer to make dashboards and reports run at high speed. Samples scripts and the necessary mapping into the Oracle Business Intelligence Enterprise Edition Repository are also reviewed, plus architect and project manager considerations. The context is Oracle Business Intelligence Applications 11g, but the concepts are equally valid for custom-built solutions.”

Download the pdf from the above link.


Webinar: A Mix of Art & Science: How to Achieve High Performance Business Intelligence

Performance Tuning Oracle’s BI Applications

Contact details:

Contact Jeff via his LinkedIn profile or his blog