Saturday, September 17, 2011

OBIEE Presentation variable defaulted by a session variable

Did this one on the OTN forum. Open the filter and add a presentation variable:

image

Say P_SELECT_DATE

image

Add a default date well outside the feasible range.

Press add more options and add a session variable LAST_REFRESH_DATE:

image

The filter will now look like:

image

Till Next Time

2 comments:

Anonymous said...

Thanks for your info! Nice presentation, wonderfully helpful article!


Sample forms

s1t0 said...

Hi, I have a question and maybe you can help me I hope so. I want to filter rows in an answer based in the that has been logued in. Im thinking that I can do it using an sql expression or maybe using a session variable. Can you help me with this? How can I do this? I really would appreciate it. HELP ME PLEASE