Thursday, January 9, 2014

OBIEE - Session Variables are not updated problem

When you are using Session Variables, with Row-wise initialization.
In case you have a problem with those session variables not being updated, unless you restart the BI server...
Please make sure that the "use caching" option is turned off. Otherwise the Session Variables are not refreshed each time you log in.

(The use caching is very useful in many other cases).



1 comment:

  1. Hi,
    I use a condition comparing the login( USER()) and a data os as to filter information for each user. It works fine but when logging in the user sees the data of the previous update. It means that to make the condition work the user has to update the analyses just after logging in.
    So, how do you manage the update of the function USER() at each new connection ?
    Thanks in advance,
    ET

    ReplyDelete