OBIEE 11G: Prompt on Dashboard
I have a dashboard that has 5 separate pages.
These pages are based on RLS within OBIEE. Each page allows users in different regions to access their data. These dashboard pages all have a similar layout. Therefore all have a prompt named Region. My issue is this: When I select one value in the Region prompt on Page 1 of the Dashboard and then Select Page 2 of the Dashboard the value I have selected carries over to Page 2 of the Dashboard. I would like to prevent this from occurring. I have actually limited the values as well. So the value that is being carried over should not be able to be selected because the value is not listed in the specified user options.... Not sure what's happening. Any advice on how to resolve the issue would be great.
Not sure if this is relevant: The prompts on each Dashboard Page are linked to a Saved Filter for that Dashboard Page. Each Dashboard Page has their own respective filter.
This is mainly an issue within my analytics team, because members have access to all 5 dashboard pages. It is not an issue for others because the RLS prevents them from seeing the other dashboard pages. Just the same it is extremely annoying to have to reset the filters when toggling back and forth...
Answers
-
Did you set the scope of your prompts to the page instead of the dashboard? (on option on the prompt when you edit the dashboard pages)
What you see now (the value being passed between pages it's because the logical column used in your prompts for region is the same on all the pages and most of the time you would expect the BI solution to bring selected values with your when you navigate through pages instead of forgetting everything and having the user to select everything again ....
And it's true that even if you limited the list of possible values of your region prompt the values of the previous page is added when you navigate with a dashboard scope on your prompts...
0 -
I looked at the prompt and it appears that it is not set to all pages. Is this the option you're referencing or is it specific to the fields within the prompt
0 -
Gianni,
Thanks again for the help. I tried to edit my previous post to add this information but, I did not see an edit button.
I found the option in the dashboard itself as well. I see that the option on the Dashboard Page when I right click on the Prompt has the Scope selected as Page with a blue dot beside it.
0 -
Actually it's when you edit the dashboard page, you go to the properties of the dashboard prompt you added in the page and there you find "Scope". By default it always set itself on the "Dashboard" value. Switch it to "Page" and try again. (You must do that on all the 5 pages)
0 -
I'm wondering if using presentation variables for all of your prompts would help with this.
For instance...
On page ONE you have prompts:
Region (set this to populate presentation variable vRegion1)
Country (set this to populate presentation variable vCountry1)
State (set this to populate presentation variable vState1)
Then on page TWO, you have prompts:
Region (set this to populate presentation variable vRegion2)
Country (set this to populate presentation variable vCountry2)
State (set this to populate presentation variable vState2)
Page THREE...
Region (set this to populate presentation variable vRegion3)
Country (set this to populate presentation variable vCountry3)
State (set this to populate presentation variable vState3)
And so on...
And for your reports:
Page ONE reports have filters:
Region is equal to/is in @{vRegion1}{%}
Country is equal to/is in @{vCountry1}{%}
State is equal to/is in @{vState1}{%}
Page TWO reports have filters:
Region is equal to/is in @{vRegion2}{%}
Country is equal to/is in @{vCountry2}{%}
State is equal to/is in @{vState2}{%}
Page THREE reports have filters:
Region is equal to/is in @{vRegion3}{%}
Country is equal to/is in @{vCountry3}{%}
State is equal to/is in @{vState3}{%}
And so on...
0 -
The scope is set to Page for all prompts in the option you reference above. Is it possible that this is some sort of issue with the software itself? The behavior is inconsistent.... sometimes it saves the Filter for Region when switching pages and sometimes it doesn't.
0
