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

    OBIEE 12C -  row-wise initialization issue

    vai

      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 - (11.1.1.7), 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 -

       

      ERRORS:

      GLOBAL:

      [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 12.2.1.2 on Windows server -2012 R2  and have scaled out horizontally.

      Also we are using Windows AD  for authenticating users.