1 Reply Latest reply on Dec 30, 2016 4:41 PM by Gianni Ceresa

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

    2714750

      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.