Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Dashboard prompt scope when using subpages
Hi,
I wonder if anyone can help please.
We used to have three separate dashboards when using 11g, but have merged them into one dashboard in 12c and used the subpages feature to organise the dashboards. So we have three main dashboard pages, and each main tab has a number of subpages.
This has raised an issue in that the dashboard prompts we had before, whose scope were set to dashboard, now apply to all three main dashboard pages, when we wanted the scope to apply to the main dashboard page and each of the subpages.
Does anyone know if there is a way to set the scope of the prompts to the dashboard page and its subpages, rather than to the entire dashboard or just the one subpage?
Thanks in advance
Answers
-
The way I have gotten around this is by changing the formula for the prompt.
I'll try to explain.
If I have 3 dashboard pages that have prompts for 'Customer Number' and I want each of those prompts to act independently in scope, then I do the following:
(1) Page1 prompt:
(a) I go into the formula for Customer Number in the prompt and set it to be:
CASE WHEN 1=0 THEN NULL ELSE "Customer"."Customer Number" END
(b) Set the prompt to populate a presentation variable called vCustNum1
(c) Set the filter for all the reports on this dashboard to be:
"Customer"."Customer Number" is equal to / is in @{vCustNum1}{XXXXXXX}
(2) Page2 prompt:
(a) I go into the formula for Customer Number in the prompt and set it to be:
CASE WHEN 2=0 THEN NULL ELSE "Customer"."Customer Number" END
(b) Set the prompt to populate a presentation variable called vCustNum2
(c) Set the filter for all the reports on this dashboard to be:
"Customer"."Customer Number" is equal to / is in @{vCustNum2}{XXXXXXX}
(3) Page3 prompt:
(a) I go into the formula for Customer Number in the prompt and set it to be:
CASE WHEN 3=0 THEN NULL ELSE "Customer"."Customer Number" END
(b) Set the prompt to populate a presentation variable called vCustNum3
(c) Set the filter for all the reports on this dashboard to be:
"Customer"."Customer Number" is equal to / is in @{vCustNum3}{XXXXXXX}
I hope this helps.
0 -
Thanks very much for your reply Chris. Will keep this workaround in mind.
Does anyone else have any other ideas? (We have a lot of prompts and a lot of reports!)
0 -
Hi,
Does anybody else have another idea for the prompts to apply only to the page where it's at?
Also, can anyone provide screenshots on how to go about this workaround.
"I'll try to explain.
If I have 3 dashboard pages that have prompts for 'Customer Number' and I want each of those prompts to act independently in scope, then I do the following:
(1) Page1 prompt:
(a) I go into the formula for Customer Number in the prompt and set it to be:
CASE WHEN 1=0 THEN NULL ELSE "Customer"."Customer Number" END
(b) Set the prompt to populate a presentation variable called vCustNum1
(c) Set the filter for all the reports on this dashboard to be:
"Customer"."Customer Number" is equal to / is in @{vCustNum1}{XXXXXXX}
(2) Page2 prompt:
(a) I go into the formula for Customer Number in the prompt and set it to be:
CASE WHEN 2=0 THEN NULL ELSE "Customer"."Customer Number" END
(b) Set the prompt to populate a presentation variable called vCustNum2
(c) Set the filter for all the reports on this dashboard to be:
"Customer"."Customer Number" is equal to / is in @{vCustNum2}{XXXXXXX}
(3) Page3 prompt:
(a) I go into the formula for Customer Number in the prompt and set it to be:
CASE WHEN 3=0 THEN NULL ELSE "Customer"."Customer Number" END
(b) Set the prompt to populate a presentation variable called vCustNum3
(c) Set the filter for all the reports on this dashboard to be:
"Customer"."Customer Number" is equal to / is in @{vCustNum3}{XXXXXXX}"
Thanks
-5 -
Hi,
Does anybody else have another idea for the prompts to apply only to the page where it's at?
Also, can anyone provide screenshots on how to go about this workaround.
"I'll try to explain.
If I have 3 dashboard pages that have prompts for 'Customer Number' and I want each of those prompts to act independently in scope, then I do the following:
(1) Page1 prompt:
(a) I go into the formula for Customer Number in the prompt and set it to be:
CASE WHEN 1=0 THEN NULL ELSE "Customer"."Customer Number" END
(b) Set the prompt to populate a presentation variable called vCustNum1
(c) Set the filter for all the reports on this dashboard to be:
"Customer"."Customer Number" is equal to / is in @{vCustNum1}{XXXXXXX}
(2) Page2 prompt:
(a) I go into the formula for Customer Number in the prompt and set it to be:
CASE WHEN 2=0 THEN NULL ELSE "Customer"."Customer Number" END
(b) Set the prompt to populate a presentation variable called vCustNum2
(c) Set the filter for all the reports on this dashboard to be:
"Customer"."Customer Number" is equal to / is in @{vCustNum2}{XXXXXXX}
(3) Page3 prompt:
(a) I go into the formula for Customer Number in the prompt and set it to be:
CASE WHEN 3=0 THEN NULL ELSE "Customer"."Customer Number" END
(b) Set the prompt to populate a presentation variable called vCustNum3
(c) Set the filter for all the reports on this dashboard to be:
"Customer"."Customer Number" is equal to / is in @{vCustNum3}{XXXXXXX}"
Thanks
-5