Thursday, 10 May 2012

Oracle Business Intelligence 11.1.6.0 – Master Detail Data Linking

Master-detail linking of views allows you to establish a relationship between two or more views such that one view, called the master view, will drive data changes in one or more views, called detail views.

This is an attempt to explain how to setup and invoke master detail events on views.

Master Detail Linking
Assume that we have two views; one view which shows revenue by product lines while the other graph view that shows revenue by months with year on a section slider. Using the master-detail linking functionality one can link these two views so that when you click on particular year, the year on the section slider of the graph as well as the data in the graph changes to reflect the year that was checked on the table.
Create Master Analysis  
The analysis named ‘Product Line Analysis’ is build with following columns from ‘A-Sample Sales’ subject area.
Selected Columns




The analysis view chosen is a vertical graph and putting up the T05 Per Name Year in section as a slider. The graph view with Per Name Year in section and selecting display as slider is as below.

Designate Master Column from analysis   
Designate T05 Per Name Year as the Column that will be the master column. To designate column as master column, go to the column properties of T05 Per Name Year, choose interaction tab and set the primary interaction to ‘Send Master-Detail Events.’ Specify a channel for the detail views to be listing on. The channel specified here is ‘MD1’.
Create Detail Analysis  
Create a detail analysis called ‘Trending Analysis’ is build with following columns and filters from ‘A-Sample Sales’ subject area.
Selected Columns
Filters




The analysis view chosen is a vertical graph and putting up the T05 Per Name Year in section as a slider. The graph view with Per Name Year in section and selecting display as slider is as below.

Set Listen to Master-Detail Events Property of Graph
Edit the graph properties to Listen to Master-Detail Events. The specified channel name must match the name given in the column properties.

Test Master-Detail Linking
Test the Master-Detail by selecting one of the Year Columns on the master analysis and see the how the detail analysis chart changes along with the slider.
For Master-Detail Analysis for when Per Name Year chosen as 2009

For Master-Detail Analysis for when Per Name Year chosen as 2010.

No comments:

Post a Comment