6 Replies Latest reply on May 31, 2017 11:07 PM by Chandu K

    Passing Parameter values From one report to another - OBIEE Dashboard

    Chandu K

      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.