Action link to report on same dashboard — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Action link to report on same dashboard

Received Response
11
Views
4
Comments
RBol
RBol Rank 3 - Community Apprentice
edited Aug 13, 2024 5:52PM in Oracle Analytics Cloud and Server

Hello,

I have a dashboard with an overview of an amount of orders per day for the next week. I would like to use an action link to go to a more detailed report on what is going to arrive at a particular day. But I would like the detailed report to appear on the same dashboard and only to appear when I click on a particular day and display the details for that day. How do I configure this?

Regards,

Lianne

Answers

  • ArijitC
    ArijitC Rank 6 - Analytics Lead

    You should try OBIEE master detail reports.

    Example OBIEE 11g: Master-Detail Linking - Red Stack Tech

    If you like to explore more complex solution ...here is another food for thought...

    https://www.clearpeaks.com/pop-effect-in-obiee-using-jquery/

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    From memory I think you can put a hidden section on a page and navigate to it, but this is sometime back, so I could be wrong? (anyone done this - is my memory playing tricks?!)

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Based on your thread master-detail, as suggested by ArijitC, would be the natural answer except for a detail: you want the detail to be visible only after clicking on a day. Master-detail is more that the detailed analysis is always there and master-detail will filter based on the click.

    An alternative way based on what you ask could be a normal action link, but cheating a bit to display the detailed analysis. You can set a condition to hide/show the section of the page containing the detailed analysis. The idea is to use the condition to check if a day is set/passed as selected or not.

    In that way you would achieve what you ask for, just by cheating a bit on the show/hide of the detailed analysis.

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    I've had a lot of problems with master-detail linking across separate reports.

    I have had success using an action link in the base report that navigates to the same dashboard page.  A hidden prompt (in dashboard properties) populates a presentation variable that filters the second report.  The presentation variable has a bogus default value that prevents any action until the action link is clicked.  A condition on the section containing the second report can hide/reveal it.