Oracle Analytics Cloud and Server

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

Opening detail report on same page

Received Response
41
Views
9
Comments
RBol
RBol Rank 3 - Community Apprentice

Hi all,

I am trying to create an action link that doesn't open the detail report on another page, but adds it on the same page as the master report. I want it to be invisible at first and want it to appear whenever someone clicks on a value. I know it's possible because I've seen it before, but I can't find it anymore. To be clear: I don't want a traditional master-detail construction, because then the detail report is already visible.

Any help will be much appreciated!

Kinds regards,

Lianne

Answers

  • RBol
    RBol Rank 3 - Community Apprentice

    Hello Robert,

    Thanks for your reply. I'm afraid I haven't been very clear in describing my wishes. I would like the original report to remain on the page and the detailed report to appear on the same page (in a different section/column/...). So I don't want to navigate to a separate page.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    There proposed solution is that you replicate your entire page but with the additional analysis, then set it all as hidden.

    So your action link takes you to what looks identical to the current page but with the additional section visible.

    Make sense?

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Btw - do give yourself a user friendly display name, long time users are more likely to engage with you than if you just leave it as the default.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Hi again Lianne,

    the other thing that you could try is making your report invisible based on another report not returning data.

    Use a filter with a presentation variable with a default which will never return data, like Month = @{MyPresentationVariable}{NoMonth}

    Then have your presentation variable setting to another value in the dashboard prompt change, you can use case logic to change another value than NoMonth to the All Months like this; -

    case when @{MyPresentationVariable}{NoMonth} then 'NoMonth' else YourTimeDimension.MonthHere end

    The above is just me illustrating the concept.

  • RBol
    RBol Rank 3 - Community Apprentice

    Hi Robert,

    I'm not sure I understand your presentation variable solution, but that could just be me because I'm unfamiliar with using them.

    Your first tip worked :-) only I'm also using column selectors and my added columns disappear...because it's a different dashboard. Do you maybe have a solution for that as well?

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    No, sorry, I do not know of a means of synchronizing your column selectors too.

    On the presentation variable idea it is; -

    1. Section visible or not based on an analysis

    2. Variable drives visibility by defaulting to value that would always yield no rows via a filter on the analysis in question

    3. On selection of a dashboard prompt the variable is changed so the analysis would have rows and the hidden section becomes visible

    Hope this makes more sense?

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Did you find your answer?

    If so would you mind closing the question and marking correct / helpful as appropriate.

    If not do you still need any help?