OBIEE11g – Master
Detail View
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.
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:
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.
Note:
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
No comments:
Post a Comment