Passing Parameter values From one report to another - OBIEE Dashboard — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Passing Parameter values From one report to another - OBIEE Dashboard

Received Response
251
Views
6
Comments
Chandu K
Chandu K Rank 2 - Community Beginner
edited Aug 13, 2024 6:00PM in Oracle Analytics Cloud and Server

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.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Not sure to get exactly how your thing work. Report 2 and 3 always display data of a single customer, the one you click on report 1?

    If that's the case you better use master-detail instead of navigation.

    Master-detail will only change report 2 & 3 (both details) by selecting the customer you click on report 1 (master).

  • Chandu K
    Chandu K Rank 2 - Community Beginner

    Thanks for the reply.

    Sure, I will try 'Master- Detail' and let you know.

    Just FYI.... these three reports are from same subject area but different tables (Of course there is common dimension Customer Available.)

  • Chandu K
    Chandu K Rank 2 - Community Beginner

    Just to add that...

    These 3 reports are Independently designed and attached to a dashboard... this means: Three reports are from different analysis with different tables and Views.

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    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.

  • Chandu K
    Chandu K Rank 2 - Community Beginner

    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