3 Replies Latest reply on May 10, 2017 1:12 PM by user516448

    OBIEE 12C -  row-wise initialization issue


      I have created a non-system session variable and have used row-wise initialization for restricting user data according to their location. It worked fine in OBIEE 11G - (, when migrated the repository to 12C, the Admin tool throws error for all non-system session variables  when i use it as filter in Identity manager -> Application Roles.


      I am getting the below error while checking the consistency -




      [38197] Data filter expression "BMM"."TABLE"."COLUMN" =  VALUEOF(NQ_SESSION."location") for Application Role "BI_Consumer" is considered as non conditional, error: [nQSError: 23006] The session variable, NQ_SESSION.location, has no value definition..



      What could be the issue -

      We have installed OBIEE on Windows server -2012 R2  and have scaled out horizontally.

      Also we are using Windows AD  for authenticating users.