8 Replies Latest reply: Nov 14, 2012 10:51 AM by paamikumar RSS

    OBIEE11g - Passing prompt values between dashboard pages

    877006
      Hi,

      I am working on OBIEE 11.1.1.3 and need some help on the issue of prompts value passing between dashboard pages.

      Scenario:
      - I have built 2 reports from separate fact tables. Product and Customer are the common dimensions between these fact tables. Time dimension is different for each of them.
      - I have a dashboard and 2 pages within it - Page1 and Page2.

      Page1:
      - I have a dashboard prompt with Product, Customer and Year filters.
      - I have a report with Product, Customer, Year and Total Revenue columns.
      - I have an Action link - "Click here", which takes user to Page2.

      Page2:
      - I have a dashboard prompt with Product, Customer and Week filters.
      - I have a report with Product, Customer, Week and Total Volume columns.

      I select some values in Page1 prompts and generate a report. Then I click on the Action Link "Click here", which will take me to Page2.

      Now, in Page2, I want the common prompts (Product and Customer) to have the default values selected as those values which have been selected in the common prompts on Page1. And accordingly, the report in Page2 should be generated.

      Solutions tried:
      1. Added the below javascript in Page1 but the link, on being clicked, does not do anything.

      <script>
      function navigateToPage2()
      {
      DashboardChangePage('Path to Page2');
      }
      </script>
      Click here

      2. I set a Presentation Variable when a value is selected in a prompt on Page1. But I am unable to set this Presentation variable as the default valie in the corresponding prompt on Page2.

      Request the experts to kindly suggest how I can get this working.

      Thanks & Regards,
      Rahul

      Edited by: Rahul on Dec 1, 2011 5:10 AM