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.

Visibility of Prompts based on the Users

1.Create a section  and Put the dashboard prompt with new prompts in that section.

2. GO to permission for that section and give the roles as 'granted' for the users account  to have access to that section.

3. Create new filters in the reports for the new prompts as “Is Prompted”.

4. Then the Prompts will work and those will be visible based on the roles.