How to pass the parameter from master report to detail report? — Oracle Analytics

Oracle Analytics Cloud and Server

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

How to pass the parameter from master report to detail report?

Received Response
51
Views
9
Comments
User472204-OC
User472204-OC Rank 5 - Community Champion

For example:
In OBIEE 11G,  there are  two reports (Master and Detail ) in one dashboard, when customers click the one column named "Month" in Master report , which will impcat the detail report data based on the clicked value.
Is it possible to implement this function for using JS or handcode or variables? Thanks .

PS:

1. Customers do not want to use the Master-Detail event in columns,because it will show the  drop-down box or slider in detail report, which is not beautiful and feeling.

2. I try to use Navigate function or action link function , however, it will go to the new page, not impact the report in same page , which is not my expected result.

NavigateProblem.JPG

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    That's how master-detail linking works. If your client doesn't like it then either use Visual Analyzer/Data Visualization in 12c or get your client to change his mind. JS-hacking this in 11g isn't really the most clever way to do this since you'll have to rewrite that code for 12c for sure.

  • Andrew Fomin.
    Andrew Fomin. Rank 6 - Analytics Lead

    You can set in your DetailReport filter "Month is prompted" and navigate from the MasterReport to the same page (test_1) instead of the DeailReport.

  • Arkadip-Oracle
    Arkadip-Oracle Rank 1 - Community Starter

    Hi User472204-OC ,

    Please check below for the Master Detail report implementation :-

    https://www.youtube.com/watch?v=6zQMDpQVflI


    Please mark this response correct if its helpful for you.


    Regards,

    Arko

  • User472204-OC
    User472204-OC Rank 5 - Community Champion


    Hi  Arko,

    Thsnks for your kindly help. Your link is on Master-Detail event information,which is not my expected result.

    If I use this function, it will show the drop-down or slider in detail report. Thanks.

  • User472204-OC
    User472204-OC Rank 5 - Community Champion

    Hi  Arko, 

    Thanks.

    Although your method is not best , it meet the requirement .

    However, it will spend some time for freshing whole page when the data is big;

    So I want to know whether I can use the variable to pass to detail report.

  • Arkadip-Oracle
    Arkadip-Oracle Rank 1 - Community Starter

    Hi,

    In this method, the values are being passed onto the detailed reports using a label that you are defining. This label is then caught by the detailed report (which will be preconfigured in the report filters).

    Please mark my reply correct/helpful if it helped you meet your requirement.

    Kind Regards,

    Arko

  • User472204-OC
    User472204-OC Rank 5 - Community Champion


    Hi Arko,

    I do not understand the exact method (How to set and use the label), could you please say it more clearly? Thanks.

  • Andrew Fomin.
    Andrew Fomin. Rank 6 - Analytics Lead

    One more idea, that I've used today.

    I created a typical master-detail report with an ordinary drop-down box. And then set style "visibility:hidden;" to the column's value and header.

    This method is still not perfect because there is still a row on top of my detail report.

    ice_video_20160420-192816.gif

  • User472204-OC
    User472204-OC Rank 5 - Community Champion

    Hi  Andrewif,

    Greate , thanks very much. I do not try to use the css style.

    Firstly, I have tried to hidden the related column in colunm property(Hidden),which does not work.