OBIEE 12C - row-wise initialization issue — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 12C - row-wise initialization issue

Received Response
14
Views
3
Comments
vai
vai Rank 4 - Community Specialist

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.

Answers