Master-Detail linking - OBIEE 11g

Master-Detail linking new features included in OBIEE 11g. It was not in 10g.

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 other views, called detail views

Assume that we have three views; one view which shows “Contact Num count –Rakesh Patil” by Quarterly lines while the other two graph view that shows “Contact Num count –Rakesh” by months with prompt quarter. Link these three views so that when you click on particular quarter, month in the graph changes to as per selected quarter 

Create the simple report.

Click on “Contac Num Cout –Rakesh Pati”.Go to Column Properties and click on interaction and Go to ‘Interaction Tab –>Primary Interaction –> Send Master Detail Events àEnter the channel name , I have given “RA01”

Click on results and create a Graph view à.Edit the Graph view ,click on Graph properties –> Enter the Channel name that we specified in Master Report –i.e. “RA01”

Save the report and click on quarter. Once you click on quarter you will see the both graph will show the month as per the selected graph.

I hope you will understand..:)

Regards 

Rakesh Patil