Hi,
I am trying to implement data level security via Identity Manager in OBIEE 11g. What i want to accomplish is this:
CASE WHEN VALUEOF(NQ_SESSION."GROUP")='ManagerGroup'
THEN "Daily Sales Fact KPI"."CX_CM_OSLS_AGNT_ALIAS_REV"."SLS_AGNT_MGR_ID"=VALUEOF(NQ_SESSION.MgrId)
ELSE "Daily Sales Fact KPI"."V_ICM_TXN_KPI_EXT_ALIAS"."AGENT_ID" = VALUEOF(NQ_SESSION."USER")
END
Essentially, what i am trying to do is that if a user with 'ManagerGroup' logs in, then the data level filter should allow display of data for all agents that have this manager id, and if an Agent logs in, data level filter should allow display of only the data for that specific Sales Agent.
When i try to save this expression, i get the following error:
[nQSError: 27002] Near <=>: Syntax error [nQSError: 26012] .
What am i doing wrong? How can i implement my requirement?