Archive for November, 2011

11g Bug: Issue with equality operator on content filters

November 21, 2011

I ran into an weird issue yesterday trying to troubleshoot data security for my current gig. What it came down to is the fact that for some reason the equality operator in the expression below wasn’t being resolved correctly by OBI: LOWER( TRIM(“Data Warehouse”.””.”SCHEMA_NAME”.”ALS_BI_SEC_USER_DEPT”.”EMAIL_ADDRESS”)) = ( LOWER( TRIM( VALUEOF(NQ_SESSION.”USER”)))) Even after toying with :USER, applying […]

Tags: , , , , , ,
Posted in Business Intelligence, OBIEE, Technical, Tips, Troubleshooting | No Comments »

Changing the value of a session variable at the session level

November 12, 2011

I recently needed to update the value of a session variable beyond a prompt’s scope, I played a bit with the NQSSetSessionValue() ODBC function

Tags: , , , , , , , ,
Posted in Business Intelligence | 1 Comment »