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.

Robert Angel

Have you checked that the order execution precedence is still what it should be, so your NQ_SESSION.location is actually populated first?

vai

yes, the execution precedence is still the same.

user516448

This may help: https://biapplications.wordpress.com/2017/04/15/fixing-data-filter-expression-valueofnq_session-variable-for-applicaton-…