Send Master-Detail Events in OBIEE

Master-detail linking of views:

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, suppose you have the following two views:

• A table that shows Dollars by "Per Name Year"
• A graph that shows Dollars by LOB with "Per Name Year" on a section slider

Using the master-detail linking functionality, you can link the two views so that when you click a particular "Per Name Year" in the table, the "Per Name Year" on the section slider of the graph as well as the data in the graph changes to reflect the "Per Name Year" that was clicked on the table. 

For example, clicking 2008 in the table in the "Per Name Year" column, positions the thumb in the section slider on 2008 and updates the data in the graph to the data for 2008.

Note: Master-detail linking is not supported when you click the plot area of a graph.

What Are Master Views actually?

A master view drives data changes in one or more detail views. A view becomes a master when you set up the interaction of a column in the view to send master-detail events on designated channels. This column is known as the master column.

The master column is the column whose values when clicked send a master-detail event, which passes information to update the data in a detail view.

A master view can be in the same analysis as the detail view or in a different analysis. A master view can update data in one or more detail views.

The following types of views can be master views:

• Graph
• Funnel graph
• Gauge Map
• Pivot table
• Table
• Trellis (only the outer edges, not the inner visualizations)

What Are Channels?

A channel links a master view to a detail view. It is the vehicle that carries master-detail events from the master view to the detail view. The same channel must be used for both the master view and the detail view in a master-detail relationship, for example, PassYear. Note that the channel name is case sensitive.

What Are Detail Views?

A detail view is a view that listens for and responds to master-detail events sent by a master view on a specified channel. A view becomes a detail view, when you set up the view to listen to master-detail events.

A detail view includes one or more columns whose values are changed directly by the information passed by a master-detail event. These columns are known as detail columns.

A detail view can:

• listen for master-detail events from multiple master views
• be in the same analysis as the master view or in a different analysis
• not act as a master to another view

Say for example, we'll take above scenario.

• Go to criteria of the above example.
  
• Go to column properties of "Per Name Year"
  
• Move to Interaction tab of the column properties.
  
• In Primary Interaction, select Send Master-Detail Events and Specify Channel name for this master detail event.
  
• Click OK.
• Move to the Results section of the analysis.
• Click an Edit mode of the bar graph view.
• Move "Per Name Year" to Sections and select "Display as Slider".
  
• Now click Edit Graph Properties button of the graph.
  
• Select Master-Detail check box, the Text Box for Event Channels will get enabled.
• Remember the channel we have defined in previous step. i.e. PassYear
  
  
• Click OK.
• Click Done to return to the analysis page.
• Now you can select any of the value for Per Name Year column in this analysis, the corresponding details report i.e. here Bar Graph View will get changed.

Happy stay.. :-)