In this post i will show how to make dashboard names as prompts with a list of names(drop-down) using guided navigation concept .I am doing with Sampelsales catalog.
I will show you the 02 History & Benching and 03 Tering & Distribution dashboard as drop down in prompts.
Step1: Creation of a prompt any dummy column in Fx give this formula
CASE WHEN 1=0 THEN "Column_Name" END
Step2: In "Show" section use SQL Results instead of All Values,sql to be like this
SELECT CASE WHEN 1=0 THEN "D2 Market"."M01 Market" ELSE '02 History & Benching' END FROM "Sample Sales"
union all
SELECT CASE WHEN 1=0 THEN "D2 Market"."M01 Market" ELSE '03 Tiering & Distribution' END FROM "Sample Sales"
Step3 :Assign a presentation Variable to that prompt in the below picture you can see thatone
CASE WHEN 1=0 THEN "Column_Name" END
Step2: In "Show" section use SQL Results instead of All Values,sql to be like this
SELECT CASE WHEN 1=0 THEN "D2 Market"."M01 Market" ELSE '02 History & Benching' END FROM "Sample Sales"
union all
SELECT CASE WHEN 1=0 THEN "D2 Market"."M01 Market" ELSE '03 Tiering & Distribution' END FROM "Sample Sales"
Step3 :Assign a presentation Variable to that prompt in the below picture you can see thatone
Step4: The prompts to be like this
Now we have Dashboard names as drop down in a prompt.But,we have to show related reports for a dashboard.This can be achieved by using Guided Navigation feature available in obiee.
Guided Navigation is used for Report placeholders(Sections) .The section will show based on the intermediate report condition.
Create intermediate report and pull dummy column
Later use the same report in guided navigation section .So,if any user select 02 History & Benching itshould the respective report which should satisfy above condition
Step5:
Section 2-->Properties-->Guided Navigation-->If this section condition satisfies it will show Bench To Individual Trended report Like this for all the 03 Tiering & Distribution related reports use the same condition For the 03 Trending & Distribution do the same but we have to use different guided report by changing the filter condition to 03 Trending & Distribution
'03 Trending & Distribution is equal to /is in @{DashobardName}
Step6:
Finally,place all the reports related to both dashboards in a single page and give appropriate guided navigated report based on filter condition(DashboardName).So that when ever a user selects a Dashboard Name(in prompts) .It will pick up those sections using guided navigation condition report.The following two figures shows you
Posts
