This content has been marked as final. Show 8 replies
It feels quite weird that you had created 70 distinct analyses rather than a smaller number with a bit more clever filtering.
Anyways, you can achieve this by putting conditions on the sections within the dashboard page. Depending on your selections in the prompts, this will then hide and show the equivalent sections.
This said...the page will be a nightmare and you will need 70 conditions, so don't expect this to be performing nicely. Maybe take a step back and think about whether you actually need 70 distinct analyses. If you do...good luck with creating that page, it shuold be fun.
The concept isn't very hard, once you have understood the bits and pieces and put them together nicely.
Venkat wrote on it initially here: http://oraclebizint.wordpress.com/2008/01/17/oracle-bi-101332-selecting-reports-from-dashboard-prompts-and-guided-navigation-sections/
John picked it up later: http://obiee101.blogspot.ch/2010/07/obiee-using-prompt-as-report-selector.html
In order to reduce the number of analyses, you can even push this concept further by playing with dynamic prompt content:
The links are about creating a dashboard prompt to list down specific report names and while selecting the report names the user wanted to show those corresponding reports within the dashboard.
But my requirement is to limit the reports based on selection of table name. there are 6 tables and assume 10 reports for each table and i want to display on ly 10 reports when the user select table name( Radio button).
Is this requirement is achievable?? or should i have to create in different pages for each table.?
This is in OBIEE 11G
Did you read the blog posts? If yes, then your question below should not be necessary since the answer is contained in them and in what I wrote above.
there are 6 tables and assume 10 reports for each table and i want to display on ly 10 reports when the user select table name( Radio button)This means 6 conditions evaluating to TRUE based on the selection in the prompt. Those conditions will then reside as controlling conditions on the dashboard sections containing the analyses.