9 Replies Latest reply on Mar 15, 2019 10:21 PM by Christian Berg

    Data Security setup using Session Variable Initialization Block fails with nQSError:23006 OBIEE 12.2.1.4.0

    3822729

      Hello Experts,

      We have OBIEE 12.2.1.4.0 on Linux server. Trying to implement data security using session variable Initialization Block. Performed these steps -

       

      1. Created Inti Block - "Authorization"

      2.  Non-System session variable 

       

      3.  Defined a Data Filter for BIConsumer Application Role using the session variable.

       

      4. Also, I tested the Init Block by passing a valid username and was able to retrieve data from the SQL

       

      When I login to analytics and run the query , I receive an error [nQSError: 23006] The session variable, NQ_SESSION.Reg_Cd, has no value definition. 

      Can you please tell me where I went wrong in this setup. Any help is much appreciated

       

      Regards

      Rakesh