When the user clicks on a drilldown column of Report A , Report B should change data for that drille — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

When the user clicks on a drilldown column of Report A , Report B should change data for that drille

Received Response
1
Views
4
Comments
3174977
3174977 Rank 5 - Community Champion

Hi All,

Here is my report. I have two reports (one report with drilldown link 'A' & the other is report with graph 'B'). So if the user clicks on a particular drill down link of the report a the reprort B should change with that particular values along with the graph in the same dashboard page. Can this be possible..For more details please see the below.

Capture.JPG

This is report A. So when the user clicks on any particular project the report B along with graph should change for that particular project in the same dashboard page.. Below is the report B.

Capture1.JPG

It is defaulted to a particular project.. But the requirement is when the user clicks on a project from report A , report B should change for that particular project name in the same dasboard page.. How to achieve this..

Thanks !!

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Master-Detail events ... looks like from your screen shots you might need to upgrade to get that functionality (11g has it)

  • 3174977
    3174977 Rank 5 - Community Champion

    Hi Thomas,

    We are using 11.1.1.7.140415. Will master detailing works for two different reports in the same dashboard page ? Also, I am already using action links for the column project name in in report A. How can both be possible ? (Master Detail & Action links )

    Thanks !

  • 3174977
    3174977 Rank 5 - Community Champion

    Hi Thomas,

    Even if I use the master detail and action links the graph view for the selected project name will change. But how to make the table view also change for the selected project name..In my case whatever the project name we select both table view and graph view should change for the selected project name.

    Please help me with the suggestions. !

    Thanks

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Yes, you have the functionality in that version ...

    You might need to separate the functionality to different columns to achieve the total effect.