nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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

User472204-OC

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.

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

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.

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

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

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

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

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

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.

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.

User472204-OC

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.