OBIEE 12C - row-wise initialization issue

Question

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.

user516448 · Answer

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

vai · Answer

yes, the execution precedence is still the same.

Robert Angel · Answer

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