Using system session variable NQ_SESSION.ROLES in initblock

User_28Q0J

Hi

How to use system session variable NQ_SESSION.ROLES inside a initblock with some case condition and store the result into a variable. This variable will be further used to hide presentation columns

The initblock query would be,

case when NQ_SESSION.ROLES like '%Admin%' then 0 end  --> The output of the statement will be stored in a session variable

But am stuck at what will be the "from clause of this initblock query" keeping it dual doesn't work.

Thanks

Joel

Something like this if you have an Oracle data source:

SELECT

CASE ...

FROM DUAL

User_28Q0J

Hi

Tried with dual but always the session variable takes the default initialization value!!

Joel

Which version of OBIEE is this?

[Deleted User]

Did you flag it as "Security sensitive"?

Joel

Could be the dreaded session variables bug if this is an old 12c version.