I'm using shared logon in Essbase connection pool.
I tried to implement row-level security in the same process followed for relational source - create initialization block using security_table, assign returned business_units to session variable(with row-wise initialization) and use the session variable in Application roles :
VALUEOF(NQ_SESSION.SEC_BU_CUBE) <> 'NO_ACCESS' AND VALUEOF(NQ_SESSION.SEC_BU_CUBE) <> 'FULL_ACCESS' AND "GL_Balances_Cube"."Business_Unit"."Business Unit Description" IN (VALUEOF(NQ_SESSION.SEC_BU_CUBE))
No error comes in consistency check.
The same statement works for relational source, but Essbase report is throwing error - a generic error message. Please help. It is very urgent.