Passing Parameter values From one report to another - OBIEE Dashboard

Question

Hi All,

I have Developed a dashboard with 3 reports:

Reports:

1: Customer Details -                     Customer ID, Name, Location, Grade         (Displays Top 25 Customers by Grade EX: CustID 1001,Name Peter, Location: New York, Grade:3   )

2: Customer expenditure details -  Customer ID, Items, Purchased Amount, Year Month  (Displays data by Month. EX: CustID 1001, Items 20, Purchased Amount $1500, Year Month: 2017 March)

3: Raw data of the Customer-        Customer ID, Name, Item, Item Desc, Year Month, Frequency of purchase  (Displays Raw data/Detailed Transactions:  EX: CustID 1001,Name Peter, Item ACB101, Item Desc Miscellaneous Item, Year Month: 2017 March,Frequency of purchase monthly )

In Report 1 - when user clicks on Customer ID, the two other reports(2 & 3) must display data respective to that customer.

Dashboard Working perfectly, I have achieved this by using action links- Navigate to a web page.

My Scenario/Problem:

As report 1 displays Top 25 Customers by grade, If a user click on next top 25 which is 26-50 and clicks on 30th Customer ID:

Reports 2 & 3 are able to display the data for 30th Customer, but Report 1 displays Top 1-25 Customers (instead of 26-50 Customers)  -As the whole dashboard refresh.

Please advise.

Regards,

Chandu.

Chandu K · Answer

Master-Detail is working fine, as individual report.... A report with multiple views.

But if I use multiple master-detail reports in the same dashboard with a common column   --- Currently this is not working.

I am still working through this, will let u know, if this is successful.

Thanks for your inputs @Robert Angel & @Gianni Ceresa

Robert Angel · Answer

Hi,

you can also use hidden dashboard prompts to 'catch' the drill down on specific values in your report and set presentation variables, which you then use as the basis of filters in the target, using this technique you can get around drill limitations, it no longer has to be based on the same subject area content.

Hope this helps,

Robert.

Gianni Ceresa · Answer

Different reports, different columns ...

Master-detail to not care as long as the column "driving" the logic (customer) is the same one, and it's your case !

Master-detail is often used inside the same analysis to drive different views, but can always perfectly works between different analysis in the same dashboard page.

So there is no reason why it wouldn't be what you look for: it does exactly what you described.