General OBIEE

Get Involved. Join the Conversation.

Topic

    Kate Burk
    Master Detail Event Link between two pivot tables in same...Answered
    Topic posted November 18, 2015 by Kate BurkRed Ribbon: 250+ Points, tagged OBI Answers, Reports 
    228 Views, 2 Comments
    Title:
    Master Detail Event Link between two pivot tables in same report
    Content:

    I am creating a report with three pivot tables in it. I want to be able to link them all through a Master Detail Event Link in one of the pivot table filters. However, I am having trouble connecting them like I do in other reports between a table and a graph.

    Does anybody know the steps to link pivot tables together?

    Best Comment

    Gail Langendorf

    This should work (although I haven't done your exact scenario). I have a list view, a graph view & a pivot table. The list view is the master interaction. When I click on the column with the master event interaction, the graph view and the pivot table both change based upon my selection. Is that what you need? If so, then you need to set the properties for the pivot table to listen to the master interaction on the channel that you set up. In the Results tab, click on the View Properties icon for the pivot table/s. Check the Master-Detail box on & enter the event channel name, for all your views. Also it might be worth noting if you right-click on the master event column value, you will see "Send Master-Detail Event" (or Drill based upon your data) that could be a step that you're missing.

    Comment

     

    • Ashish Harbhajanka

      Hi Kate,

      I have never tried this out but if you give the steps of how you have created the pivot tables ( probably a Catalog file using Archive option) then I will unarchive the same and try to do the link part

      Awaiting your response...

      Regards

      Ashish

    • Gail Langendorf

      This should work (although I haven't done your exact scenario). I have a list view, a graph view & a pivot table. The list view is the master interaction. When I click on the column with the master event interaction, the graph view and the pivot table both change based upon my selection. Is that what you need? If so, then you need to set the properties for the pivot table to listen to the master interaction on the channel that you set up. In the Results tab, click on the View Properties icon for the pivot table/s. Check the Master-Detail box on & enter the event channel name, for all your views. Also it might be worth noting if you right-click on the master event column value, you will see "Send Master-Detail Event" (or Drill based upon your data) that could be a step that you're missing.