Displaying the OBIEE Reports based on the dropdown selection from Dashboard Prompt

1. Create a new Dashboard Prompt with all the Report names as dropdown list.

• ·             We need to change the Prompt for Column to single quotes.

• ·             Select “Specific Column Values” from “Choice List Values”

• ·             Select a “Default selection” by selecting “Specific Value”

• ·             Set a Presentation Variable as Required.

         

2. Create Intermediate(Dummy) Report for every Report (In the Dropdown) by taking one column by placing a filter as “Report name=Presentation Variable.”

        

3. Create a Dashboard and Integrate the Prompt and the Reports into it to the sections.

4. After Integrating the Reports in the Dashboard we need to set the condition at Section level.

        

5. We need to set the condition for the all Reports Sections by selecting respective Intermediate report.