Today afternoon I got an idea of "Drop Down Reports"
There might be a better solution:), my thought process working on it.
To get start with
Problem:
Want to display report based on report selection from Drop Down control in OBIEE.
Solution:
Step0: Have a logical column("Report Name" in my example)with all reports to display.
Step1: Create a request with only one Report Name logical column.
Step2: Add 2 filters, first one is "is prompted" and second one is "is equal to ADAMS"(here "adams" is my report name).
Make this column as invisible.
Step3: Make this column as “hide”
Step4: Save request as “to display report xyz”
Repeat step1 to step 4 for each and every report to display on page.
Step 5: Now create a page/dashboard prompt with same logical column as in step1 i.e “Report Name”
Step 6: Operator as “is equal to”
Step 7: Control as “Drop Down”.
You can choose Multi Select control to display multiple reports on same page.
Step 8: Save this prompt.
Step 9: Create new page on dash board
Step10: Add Section, say Dash Board Section.
Step11: Drag and drop dash board prompt (step 8 one) to this section.
Step 12: Add one more section say “Section to display ADAM report”
Step13: Drag and drop “to display report xyz” request (Created in step 4)
Step 14: Drag and Drop request “XYZ” i.e Report to display on page.
Step 15: edit step 12 properties, Choose Guided Navigation link as following
A: Reference Source Request option to “YES” and
B: Source request url as STEP 4 one.
C: Show Section option enable for “If request returns rows”
Repeat Step 10 to Step 15 for each and every report to display on page.
Step 16: Save this page.
Now dash board looks like this, when Drop down Report Select is “Clark”. Dash Board shows only specified report rest every report are hidden.
Like this, I have achieved this requirement.
There might be a better solution:), my thought process working on it.
To get start with
Problem:
Want to display report based on report selection from Drop Down control in OBIEE.
Solution:
Step0: Have a logical column("Report Name" in my example)with all reports to display.
Step1: Create a request with only one Report Name logical column.
Step2: Add 2 filters, first one is "is prompted" and second one is "is equal to ADAMS"(here "adams" is my report name).
Make this column as invisible.
Step3: Make this column as “hide”
Step4: Save request as “to display report xyz”
Repeat step1 to step 4 for each and every report to display on page.
Step 5: Now create a page/dashboard prompt with same logical column as in step1 i.e “Report Name”
Step 6: Operator as “is equal to”
Step 7: Control as “Drop Down”.
You can choose Multi Select control to display multiple reports on same page.
Step 8: Save this prompt.
Step 9: Create new page on dash board
Step10: Add Section, say Dash Board Section.
Step11: Drag and drop dash board prompt (step 8 one) to this section.
Step 12: Add one more section say “Section to display ADAM report”
Step13: Drag and drop “to display report xyz” request (Created in step 4)
Step 14: Drag and Drop request “XYZ” i.e Report to display on page.
Step 15: edit step 12 properties, Choose Guided Navigation link as following
A: Reference Source Request option to “YES” and
B: Source request url as STEP 4 one.
C: Show Section option enable for “If request returns rows”
Repeat Step 10 to Step 15 for each and every report to display on page.
Step 16: Save this page.
Now dash board looks like this, when Drop down Report Select is “Clark”. Dash Board shows only specified report rest every report are hidden.
Like this, I have achieved this requirement.