OBIEE Presentation variable stops refreshing

user4109719

I use a column filter in an OBIEE analysis that is based on a presentation variable that is set when selecting a date from the dashboard prompt.  The date is one of three columns to select from the prompt.

This is the column:  TIMESTAMPADD(SQL_TSI_MONTH, -11, "Receipt Organization Summary Fact"."Month")

The filter on the column is:  "is less than or equal to @{p_month}" where p_month is the presentation variable set by the prompt.

The problem is that after I make more than one selection and retrieve the results and then navigate to another dashboard page (by clicking on the desired month in the bar chart) , p_month stops refreshing and retains a previous value.  I proved that by looking at nqquery.log.  After returning to the first dashboard page, executing the prompt gives the incorrect date range or says there are "No Results" when there should be some. 

If I remain on the first page and make different selections it p_month updates correctly.  There are some hidden dashboard prompts that set other presentation variables when navigating, including one that contains the date clicked on - but the name of the other presentation variable is not p_month.

The OBIEE version is 11.1.1.7.150120.

user4109719

Actually the presentation variable is updating correctly.  I put it in a text box on the page and it is showing the correct value.  OBIEE is just not executing the query based on the new value of the presentation variable, after navigating to the second dashboard page by clicking on a bar representing a particular month.  If I go to the second page by selecting the tab without clicking on anything, it continues to work correctly after selecting another date in the prompt.

Sherry George

What happens if you Reset the prompts and apply the values again?

user4109719

Reset doesn't fix it. 

Another thing I've discovered is that navigating to an analysis on the page, rather than the dashboard page, doesn't cause the problem.  I tried removing all the analyses from the page so it's just a blank page and the problem still happens.  Returning to the page with the prompt is done by selecting the tab.  Perhaps this is some kind of bug.

user4109719

I created a "Back" button on the second page and using that instead of selecting the tab to go back to the prompt page doesn't cause the issue.  I assume that's why navigating to the analysis worked, because the tabs disappear and you have to click "Return".  I doubt this is the intended behavior.