Thursday, July 22, 2010

OBIEE using prompt as report selector

Yes, I know Venkat did it before:
http://oraclebizint.wordpress.com/2008/01/17/oracle-bi-101332-selecting-reports-from-dashboard-prompts-and-guided-navigation-sections/
So I will do it again so you can all reference mine ;-)
Create a prompt with a dropdown list of your reports:
image
image
If you can use an LOV instead off the CASE 1=0 construction!
put it all in a presentation variable
Add some dummy reports which only rows if the right pReports are selected:
image
image
Add the prompt and your real reports to your dashboard, give each report a separate section:
image
Set the Guided Navigation:
image
image
And Now you have a report selector:
image
image
Till Next Time

3 comments:

Ash said...

As the SQL is processed for all reports at the back end it leads to performance issues.
Can we expect something better in OBIEE 11g?

Ash

David said...

Hello John

I have several reports on the same page.
I need to use a prompt for the User to change the period of the semester report. however, it is necessary for the prompt change only the selected reporting period and not all reports of the page.

Could you help me with this?

Thanks

John Minkjan said...

@David,

How did you set the scope of the prompt? Have you considered using presentationvariables?

regards

John

Een Job bij Ciber NL?