Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Presentation Variable scope in OBIEE 11g

3347281Apr 18 2017 — edited Apr 19 2017

Hello there,

I have a dashboard prompt with two Variable Prompts on Date field, populating two presentation variables: Current_Date_From and Prev_Date_From. The default values for these variable prompts are taken from 2 different Server variables: CURRENT_FSCL_YEAR_START_DT and PREVIOUS_FSCL_YEAR_START_DT respectively.Presentation Variable Current.pngPresentation Variable Previous.png

I use this dashboard prompt for a dashboard report (lets call it Summary). I have an action link from Summary to Details report and I try to use the same Date field as report filter in Details report as shown here

pastedImage_5.png

Now the issue I am facing here is that the Date field always has the value from presentation variable Prev_Date_From. I did try to use the Current_Date_From variable in the filter, as shown below, but even it does not work and the field always have Previous year's start date.

pastedImage_6.png

Is this an issue with the value of the Current_Date_From being overridden by value of Prev_Date_From or with the scope of the presentation variable itself?

Any pointers / suggestions in this regard will be helpful.

Thanks

Anamika

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details