OBIEE 11G: Prompt on Dashboard

Question

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...

mrmmickle1 · Answer

@Gianni

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.

Chris Arnold · Answer

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...

Gianni Ceresa · Answer

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)