OBIEE 12c row level security on Essbase data source not working

Question

Hi , 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. Regards.

Gianni Ceresa · Answer

Hi,

2714750 wrote:...but Essbase report is throwing error - a generic error message.

Why not to post the "generic error message" ? Because there are hundreds of "generic error messages" in OBIEE / Essbase.

Did you checked the logs for the generated MDX? Is it a valid MDX?

In general I would say that for Essbase you better your Essbase filters for doing that.

Something like this https://www.rittmanmead.com/blog/2013/08/obiee-11-1-1-7-essbase-essbase-filters-within-fusion-middleware-11g-security/ , also covered in the doc here Configuring Data-Level Security Using Essbase Filters