Extra Pages

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:

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


    Sample forms

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

    ReplyDelete

Note: Only a member of this blog may post a comment.