Oracle Business Intelligence and Data Warehousing Practice Notes and Knowledge Repository

  • About Me

    Hello Friends,

    This is Santosh Kumar Gidadmani, a Business Intelligence and Data Warehouse Enthusiast passionate about blogging articles in the BI, Data warehousing, space. This is my attempt to share my experience and knowledge on Oracle BI & Data Warehousing Subjects.

  • OBIEE 11g Certified Implementation Specialist

  • Oracle Partner Network Certified Specialist

  • Visit My Profiles

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 73 other followers

  • Blog Hits Since Nov 2010

    • 364,321 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

Archive for April, 2012

OBIEE11g – RCU Metadata Source Change

Posted by Santosh Kumar Gidadmani on April 21, 2012

Before installing OBIEE11g, it is mandatory to install RCU because it creates repository metadata into the database. If you want to change the metadata repository to some other database due to various reasons, you can do it.

Scenario: System 1 – OBIEE11g and database (orcl1) with RCU metadata repository. System 2 – Database (orcl2). You can change the RCU repository metadata from one database to another database without impacting the current installed OBIEE11g environment.

Firstly, ensure the RCU Repository metadata is created in the new database.

Logon to Weblogic Server Admin Console
Click on services

Click on Data sources

Click on bip_datasource and click on connection pool

Click on “Lock & Edit” button

Provide the new database details like host name, instance and password as shown above.

Do the same for all four data sources (EMPsystemregistry, mds-owsm, rtd_datasource), save and activate changes.

Logon to Enterprise Manager

Go to Business intelligence folder – coreapplication – deployment – scheduler.

Provide the new database details, apply and activate the changes.

Restart the services and run the analysis (analytics).

– Santosh

Posted in Enterprise Manager 11g, OBIEE 11g, OBIEE 11g Errors, OBIEE 11g Installations, Weblogic Server | Leave a Comment »

Gartner Magic Quadrant for BI – 2012

Posted by Santosh Kumar Gidadmani on April 3, 2012

Gartner research published the 2012 BI Magic Quadrant in Feb and Oracle BI is leading the market as per the survey conducted by Gartner.

– Santosh

Posted in End User Analysis, Gartner BI Survey, OBIEE 10g, OBIEE 10g Concepts, OBIEE 11g, OBIEE 11g Analysis | Leave a Comment »

OBIEE11g – Master Detail View

Posted by Santosh Kumar Gidadmani on April 1, 2012

Master detail linking of views enables you to establish a relationship between two or more views such that one view, called the master view, drives data changes in one or more other views, called detail views.

For example, If you have the following two views: A table that shows Revenue by Brand and A graph that shows Revenue by Product Category with Brand on the graph Prompt section.
Using the master detail linking functionality, you can link the two views so that when you click a particular Brand in the table, the Product Category on the Prompt section of the graph as well as the data in the graph changes to reflect the Brand that was clicked on the table.

Master Views: A master view is one which, primary interaction value in the column properties have set to Send Master-Detail Events using a channel name.

The following types of views can be master views: Graph, Funnel graph, Gauge, Map, Pivot table & Table.
The following types of views can be detail views: Graph, Funnel graph, Gauge, Table & Pivot table

Let us see How Master Detail Linking Works:

Let us take an example and select few columns including Brand, Revenue and Product Category.

Go to the Revenue Column properties and click on Interaction.

Select Primary Interaction “Send Master-Detail Events” and specify the Channel: Channel01. This channel name should match with channel name which we will update in the graph.

Create a simple table view or pivot view to show the Revenue by Brand.

Create a simple Graph view as below

Select on the graph properties

Check on the “Listen to Master-Detail Events” and provide the same channel name as given in Revenue column. This channel name will link the master view. Ensure to have the Brand column either on Graph prompts or on Section as Slider.

Add these two views into the compound layout.

When you click on any of the Brand Revenue Value, the Graph view will automatically change the view to bring the Product Category Revenue details for the Brand value clicked.


1.Master View:
a. Master column cannot be displayed on the prompt section or on the section slider in the master view. It must be displayed in the body of the view. In our example, the revenue column is the master view and it is present in the body of the view.

2.Detail View:
a. Can listen to master-detail events from multiple master views
b. Can be in the same analysis as the master view or in a different analysis
c. Cannot act as a master to another view

– Santosh

Posted in Master Detail View, OBIEE 10g, OBIEE 11g, OBIEE 11g Analysis, OBIEE 11g Concepts, OBIEE 11g Dashboards | 3 Comments »

%d bloggers like this: