Friday, 8 March 2013

OBIee certifications

2 main certifications (implementation specialist) are available for OBIee : one for 10g, and one for 11g :

11g : Oracle Business Intelligence Foundation Suite 11 Essentials (1Z0-591) :

Link :
Topics :
Oracle BI and EPM System Overview
OBIEE Architecture
Oracle BI Installation
OBIEE User Interface Overview
Dimensional Modeling
Oracle BI Repository Overview
Build Basic Repository
Repository Testing and Deployment
Complex Repository Modeling
Advanced Repository Modeling
Building a Repository with Multiple Sources
Hierarchies and Level Based Measures
Using Variables
Implementation Methodology and Best Practices
Oracle Business Intelligence Enterprise Edition Security
Cache Management & Performance Tuning
MS Office Integration
Spatial Integration
Write Back within OBIEE
Essbase Integration

10g : Oracle Business Intelligence10 Foundation Essentials (1Z0-526) : 

Topics :
Oracle BI and EPM System Overview
OBI EE Architecture
Oracle BI Installation
BI EE User Interface Overview
Dashboards and Answers Development
Dimensional Modeling
Oracle BI Repository Overview
Build Basic Repository
Repository Testing and Deployment
Complex Repository Modeling
Building a Repository with Multiple Sources
Hierarchies and Level Based Measures
Using Variables
Using Non-Dimensional Data
Implementation Methodology and Best Practices
Oracle BI Security
Cache Management
Performance Tuning
MS Office Integration

Download OBIee


Here are the main download links for OBIee. Enjoy :)

          Note : you will need an Oracle account.

Monday, 11 February 2013

Setting up Usage Tracking in OBIee in 2 steps

Hello everyone,

Setting up usage tracking can be tricky now in 11g because it is a feature that exists for a long time now. Actually, it existed in the previous versions and has (almost) not changed over time whereas OBIee architecture changed significantly.

Step 1 :  Create required tables in database, following the scripts hosted in

Step 2 : Add the content of the rpd "UsageTracking.rpd" (found in the same directory) in your rpd :
- either using drag and drop method
- or using File->Merge utility

If you get an error message (about upgrading your repository), it means that your UsageTracking.rpd comes from the 10g version, and

Solution 1 :  it needs to be upgraded to 11g via the following commands :

set ORACLE_INSTANCE={obiee_home}\instances\instance1
cd {obiee_path}\Oracle_BI1\bifoundation\server\bin
obieerpdmigrateutil.exe -I {obiee_home}\bifoundation\OracleBIServerComponent\coreapplication_obis1\sample\usagetracking\UsageTracking.rpd -O {obiee_path}\bifoundation\OracleBIServerComponent\coreapplication_obis1\sample\usagetracking\UsageTracking11g.rpd -L {obiee_path}\bifoundation\OracleBIServerComponent\coreapplication_obis1\sample\usagetracking\ldif -U Administrator

You will be asked for a password : in 10g the rpd didn't have passwords : you'll have to choose one.

Solution 2 :  you can try to get the latest version of the rpd on the oracle support website


Notes : 

  • prefer re-creating reports and dashboards for usage tracking rather than using existing ones.
  • the "group" table may not work in 11g

Troubleshooting :
1) In the RPD : right clic -> view data  on usage tracking tables in the physical layer in order to see if tables are correctly created, seeded and mapped.
2) In Enterprise Manager : view logs for errors
3) In NQSConfig.INI file : check connection pool and database path

OBIEE Interview Questions & Answers : FAQ

1 – What is OBIee ?
OBIee is a business intelligence tool allowing to procuce reportings, mainly through a web interface.
It is a tool owned by Oracle that have been purchased in 2005 to Siebel (Siebel previously bought the tool to NQuire, which explains ‘NQ’ prefixes for configuration files) becoming Oracle Business Intelligence 10g.
11g version has been released in 2010.

2 –Architecture : what are the main components of Oracle Business Intelligence ?
OBIee (from the 11g version) runs on a J2EE application server named Weblogic, controllable by 2 interfaces : Enterprise Manager and Weblogic Console.
There are 2 main services :

  • Presentation services (corresponding to Answers and Dashboards modules to create and consult reports and dashboards)
  • Oracle BI Server (corresponding to the repository rpd containing sources mappings and business rules)

The BI Publisher module, independent in previous versions, is now fully integrated in OBIee.
It corresponds to the features "Published reportings", under New -> Analysis menu.

3 – What kind of sources can be connected to OBIee ?
OBIee can be plugged on Relational Databases, Cubes or Flat files, with the following constraints :

  • The sources must be modeled as star schemas or snowflakes schemas in order to have  an efficient and safe behavior.
  • In case of multiple sources directly in OBIee used together, be aware that OBIee will conduct the needed joins itself, and OBIee is not a database.

4 - Is it possible to create a report based on two subject areas  (example : Sales and Supply chain) ?
Theoretically, yes. In practice, the two subject area must come from the same business model in the repository, which is quite useless. Then, we can consider the two following alternatives :

  • Create an analysis with “combine request”: one subrequest by subject area. Note that it’s tricky to implement for standard users.
  • Set up a transverse subject area, that will gather tables from both business topics.

5 – How to get real physical SQL sent by OBIee to the database
First of all, check the value of your session variable LOGLEVEL.
5 is fine.
Then, go into Administration -> Manage sessions.
Find your query (at the bottom of the list), and click on “View log”.
If you hit the cache, you will see “cache hit on query”. Otherwise, you will see the physical SQL below the logical SQL.

6 – How to configure an OBIee environment ?
In OBIee 11g, main configuration items are managed in Enterprise Manager (web interface).
However, some configurations are still located in configuration files, like NQSConfig.ini, NQSCluster.ini, odbc.ini, and instanceconfig.xml

7 – In a troubleshooting perspective, how can I see log files ?
Old method in 10g version consisted in opening log files on the server.
Now, in 11g, log information is consultable in Enterprise Manager.

Tuesday, 15 January 2013

OBIEE usage over the world

Working on OBIee for several years, I always made my searches in english.
But today i was wondering how Oracle BI is used worldwide, depending on countries.

The answer is surprising :

Monday, 14 January 2013

Sort arrows and table width in OBIEE

In Oracle BI 11g, there are sort arrows by default in table views and pivot views.
The problem is that even if disabled, the arrows increase each column width, and thus global dashboard page width, and thus add horizontal scrollbars.
This is quite disturbing compared to the 10g usual appearance.

As a solution, I recommand using CSS : add a text object into your dashboard page, check the box named "Contains HTML markup" and paste the following code :

<style type="text/css">
.PT_SI {
border:medium none;

And here is the result :

Narrower table, no horizontal scrollbar :)