950780 wrote:When you say they are not working:
a brief description of my environment:
- I have one machine with all OBIEE 18.104.22.168.2 components (build 120604.0813 BP1 64bit) and Oracle Database 11gR2;
- In a separate machine I have the OID - Oracle Internet Directory where I have all business users with access to OBI Presentation Services;
- In Weblogic Console I created a user named "weblogic" and this one is the administrator of all BI environment, this user is member of BIAdministrator and Administrators group, also this user is used to perform the communication between Fusion Middleware and Weblogic;
- In weblogic Console I created a second user named "init_test" and he have the BIAuthor Role like the users that come from OID;
- I have no problem logging in with all users OID and weblogic.
- I created a simple Initalization Block and a variable to contain the result of the follow sql: SELECT region FROM adm_test_region WHERE city='Lisboa'
- Initialization Blocks for Session variables are not working for "weblogic" user. For all other users everything is working as expected (users from OID and "init_test").
- There is any restriction in terms of Initialization Blocks for Session variables regarding the user that is linking Oracle Fusion Middleware with Oracle Weblogic?
Thank you in advance,
Amith Y wrote:Hi Amith,
When you say they are not working:
1) You are using the session variables in a data filter in the RPD and for weblogic, the filter does not get applied?
2) When trying to display the value of the sessoin variable in an analysis query, it errors out saying no value?
As a BI Administrator, no data filters gets applied to the reports from the RPD unless you explicitly add them in the front end to the reports.
You can also open the RPD in online mode, and go to sessions and kill everything, login using weblogic and monitor the sessions to see if a session is being created and the list of variables getting intilialized upon weblogic's entry into analytics.
Amith Y wrote:Yes, I already did that and the result is the same but if I use a Init block with the :USER or VALUEOF(NQ_SESSION.USER) the "init_test" user can not retrieve the correct value as well!
That is a little strange, because in theory the correct value should get populated instad of the defaulted value. Do you want to try creating another init block that would actually use :USER system session variable in it to see if there would be any change in the behavior?