Master detail view in OBIEE

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.

In our example graph is master report and table view is detailed report.

What is master detail ?

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.

Detail Views: Explores the whole data as based on the master event.

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

To create master detail event we can use following steps:

1.I have created analysis as shown in screen shot.

2. Select Revenue metrics interaction property, Select primary selection as Send Master-Detail Events.
    Specify channel name here we used master_detail 

3. Create master and detail reports refer screen shot A and B.

A. Master Report

B. Detail Report 

4. Now select detail reports properties. Select checkbox in front of Master-Detail. Specify Event Channels. You can     add multiple event channels separating by coma.

5. This is the output of reports on dashboard page. To see the master detail event click anywhere on the bar graph. You will see same changes will be reflected into table.

6. Here we have selected Audio. Now we are able to see two sub types of Audio product.

7. If you want see sub types in more details, again click on the sub types. You will see all detailed information related to products in table. Refer bellow image.

8. In this way we have implemented master detail view in OBIEE.

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