This content has been marked as final. Show 8 replies
As per my idea ,create different dashboard pages for different table and navigate specific page based on the radio button table selection.Better to maintain the table name as a column in all the tables.
mark if helpful/correct..
Thank you for your reply, but the requirement is to maintain only one dashboard page, and also may i know how to navigate into specific page when you click on radio button???
I already mention that maintain one column as table so that you can filter.Else use the view selector to maintain the single dashboard page.
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.
Suppose there are 10 Reports out of 70 related to Market and i put this market as radio button prompt value, then how can i achieve this using condition in section. Can you please explain me the steps to achieve this. Your Answer will be really help me a lot.
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.1 person found this helpful
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.