Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Oracle Business Intelligence 11.1.1.9.160119 - Dashboard Prompt - Scope function not working
We have each dashboard page with defaulted filters and are being passed to the other page even though we have tried to change dashboard prompt - scope set to page filters. Anybody experienced this before, is this a bug?
Answers
-
Your question isn't very clear. If you've set the dashboard prompt scope to Dashboard then it should work across all pages within the dashboard. If on the other hand you set the scope to page, the prompt would only apply to reports on that specific page. This is OOTB functionality.
0 -
Note that this behaviour is probably not as a result of your prompts.
Try this; -
1. Set a prompt on one of your dashboard tabs
2. Go to another tab where you think that the problem lies and refresh the report
I suspect you will see that it is not effected by the dashboard prompt, unless the prompt is populating a variable and the answers report column in question is filtered by the same variable.
However, if you are navigating from one page to the other via an action link or similar on an answers report then you WILL find prompts are applied based on the combination of data you are drilling from, being caught by any 'Is Prompted' filters on the target report / page
0 -
Joel and Robert - thank you for your quick response my apologies if this wasn't clear enough. I already have dashboard with pages set and Dashboard Prompts Scope set to Page. The problem is when l move from one page to the other, it's still pulling prior parameters with it to the next page instead of using page specific parameters.
0 -
Hi 3195949 (do you ever think about changing that?)
And looking at my post, can you tell me, when you go from tab page to tab page directly, by picking the tabs, are the prompts then setting the next page value, or are you moving from page to page using any kind of report navigation where the values on the report correspond to the subject area columns in your prompts.
If the former then you do have a problem - assuming your prompts are not setting a variable which is used in both pages - if the latter then read my previous post again and check over its points....
0 -
Robert,
I am going to the page directly though these pages are using the same subject area, as shown below. I am moving from Project Phase I to Project Phase II and it's passing whatever selected values on dashboard prompt to the Phase II page when scope is set to 'Page' and not Dashboard.
0 -
And question 2 - do the prompts set a variable, so could it be that the value of {My_Variable} is the thing causing the synchronised behaviour of the prompts.
And to ask the obvious question, this is AFTER you change values on the first page, yes?
0 -
Project Phase I is defaulted to Phase I on the dashboard filter selection and Project Phase II like wise, by choosing Scope to 'Page' l would expect Phase I defaulted values should not be passed on to override Phase II defaulted values. correct me if l am mistaken on this or if l miss something here.
0 -
That is what I am attempting to do.
Put your dashboard prompt in edit mode.
Edit the prompt that is synchronising.
Check if it sets a variable value. If yes, then check the same on the 2nd page, if it sets the same value then irrespective of scope of the prompt being limited to the page, scope of the variable is not.
0 -
Robert - l think l'm lost here. The prompt on each page is defaulted to a specific value even though both pages are using the same column the specific values selected on each page are different.
0 -
Ok, now I am confused.
I thought your post was because you had two prompts on separate dashboard pages but you were finding that prompt on page 1 was causing the values on page 2 to change, and was setting the values on the second dashboard page to the values on the first.
Can you kindly clarify, and confirm exactly what you are seeing and what you want to see?
0
