Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to pass the parameter from master report to detail report?

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.
Answers
-
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.
0 -
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.
0 -
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
0 -
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.
0 -
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.
0 -
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
0 -
Hi Arko,I do not understand the exact method (How to set and use the label), could you please say it more clearly? Thanks.
0 -
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.
0 -
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.
0