Switching multiple reports using dashboard prompt in OBEE11g.

Switching multiple reports by using dashboard prompt in OBEE11g.

Requirement :  Users should able to switch multiple reports using dashboard prompt values.

Means report names  should be available in drop down list to display selected report according to client requirement.

Follow below steps if you have same requirement:

Step : 1

Click on new dashboard prompt

Step : 2

Select  variable dashboard prompt 

Step 3:

Give presentation variable name, and proper label name.

Select user Input as Choice List.

Step: 4

Here I want to switch between 3 reports, so we need to enter 3 report names which we want to switch between.

Find the screen shots below

For Report 1

 

For Report 2:

 

For Report 3 :

 

 

 

Step 5:

Now create 3 reports which you want to switch by using dashboard prompts values.

And apply some filters in theses 3 reports which will allow me to show the intended report as per selection made in the dashboard prompt.

For report 1 I added one dummy column.

Edit the dummy column formula as below and hide that column.

CASE '@{QVC}' WHEN 'Criticality Report' THEN '1' ELSE '0' END

 

 

And I have applied filter on Dummy Column as "is not equal to /is not in" '0'

 

 For report 2 I added one dummy column.

Edit the dummy column formula as below and hide that column.

CASE '@{QVC}' WHEN 'PR Count Report' THEN '1' ELSE '0' END

And I have applied filter on Dummy Column as "is not equal to /is not in" '0'

 

For report 1 I added one dummy column.

Edit the dummy column formula as below and hide that column.

CASE '@{QVC}' WHEN 'Hold Count Report' THEN '1' ELSE '0' END

And I have applied filter on Dummy Column as "is not equal to /is not in" '0'

 

Now create one dashboard page and put all reports and prompt in separate sections as shown in below screen shot.

And for report 1 go to section properties and select condition.

 

And add a new condition.

Select the report by using the browse button and give condition to display the report if the rowcount is greater than zero(>0)

 

Follow above steps to give section condition for remaining two reports.

Now save and run the dashboard.

Below are the screen shots that we are able to switch between multiple reports using dashboard prompts.