Hi all,
I’m working with OBIEE 11.1.1.7.140527, although I can reproduce the issue in OBIEE SampleApp V506, which is 11.1.1.9 version, so all the screenshots come from this SampleApp.
I have a Dashboard Prompt, DP Year, to select Year. This prompt sets a presentation variable named PV_YEAR:
I have a second Dashboard Prompt, DP Date Interval, to select two dates based on the values of the Presentation Variable PV_YEAR. They use a SQL Statement to set default values for them. One prompt is a Presentation Variable Prompt, the second one is a column prompt (as they set a time interval, I couldn’t use the same column as a column prompt, and I had to use a Presentation Variable prompt for one of them).
Now, if I use these Dashboard Prompts in a Dashboard, each time a change the Year in the Dashboard Prompt DP Year and apply, the default values for the dates in DP Date Interval get automatically changed:
But if I change one of the default dates in DP Date Interval and apply:
The next time a change Year, after applying the new value, the Date Interval default values don’t change anymore, and I have to manually change the dates.
I have disabled cache both in RPD (in the physical table used to query for the dates the Cache check is unchecked) and in Presentation Services, modifying the instanceconfig.xml to add this entries:
<Cache>
\<Query>
\<MaxEntries>100\</MaxEntries>
\<MaxExpireMinutes>0\</MaxExpireMinutes>
\<MinExpireMinutes>0\</MinExpireMinutes>
\<MinUserExpireMinutes>0\</MinUserExpireMinutes>
\</Query>
</Cache>
Is there a way to achieve the automatic change to default values each time a change the Year?
Regards