4 Replies Latest reply on Feb 27, 2015 9:24 PM by user11173172

    OBIEE 11g - The session variable, NQ_SESSION.VARIABLE, has no value definition

    user11173172

      Hello,

       

      I am seeing a  strange issue when using SESSION variable in OBIEE 11g  RPD for data level security.

       

      In RPD, I created  a new init block with session variable PRODUCT and row wise initialization is set.

       

           SQL -SELECT DISTINCT 'PRODUCT', product_id FROM BI_SECURITY WHERE UPPER(USER_ID) = UPPER(':USER')

       

      Data filter condition is set on the Fact & Dimension tables in the application role

      Based on products assigned to user in security table, data filter is applied.

       

           User A has 15 product ID's assigned

           User B has 100 product ID's assigned

       

      User A was able to login to OBIEE presentation  and see assigned product ID's being filtered in the report.

       

      But when User B logs in he sees below error , when running the same report

      [nQSError: 23006] The session variable, NQ_SESSION.PRODUCT, has no value definition

       

      Is there a limit on number of values session variable can hold.

      Why is the error occurring only for User B?

       

      Has anyone encountered this issue?

       

      Thank you