Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Saturday, 21 June 2014

Master detail linking in obiee 11g


By on 12:59:00



1. This is an extension of drilldown, Navigation.

2. So as we drill down the master, the remaining views criteria will also change depending on master.

3. "Master - detail linking" is a new type of interaction capability, extending the existing OBIEE 10g interactivity features of drill down and navigation.

4. Master detail linking allows you to click on a "Master" view to dynamically update one or more "Detail" views within the same analysis or dashboard page.



Hands On:

1. Build an analysis with following columns: Orders hierarchy, brand, per name year, revenue

2. For per name year click on more options and select column properties. Go to interaction tab, from value section, select "Master Detail Event" for the drop down of primary interaction.

3. If specify channel enter the name "Per Name Year"(It is case sensitive),(what ever name you provide here, the same name has to be provided in detailed view).

4. Click on Results.

5. Click on "New View" -->Graph --> Bar--> Vertical.

6. For the graph click on edit view, set layout as follows:

7. Under sections add Per name Year and enable the display as slider check box, add Revenue under Measures and add Brand under Groupby section.

8. Click on Edit graph properties.

9. Select listen to master detail event and provide same name you provided in master view.

10. Click on OK,Click on done.

11. Click on "Show how results look on a dashboard".

12. From master view (Pivot table) click on Per Name Year column heading and notice automatically detail view also changing.

13. Select "2009"HY2" from pivot table and notice that the slider in detailed view adjusted automatically.

Prerequisites:

1. In all the views (Master,detailed) you need to have the same column which you are identifying as a master detail event.


1 comments:

  1. Can you make a graph a master view and once you click on the a bar on the graph it drills to the details?

    ReplyDelete

Blog Archive

Labels

1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA 11.1.1.7.1 (1) OBIA 7.9.6.3 (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)