topic Re: SAS Visual analytics 7.4 Row level security - I'm not able to use the "IN" operator in SAS Visual Analytics

SAS Visual analytics 7.4 Row level security - I'm not able to use the "IN" operator

FredrikE — Fri, 26 Oct 2018 08:32:00 GMT

Hi!

Very frustrating since the documentations (http://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#n0hopehj2j9vzun1jm9rl56bpnrh.htm) says it's possible and I am pretty sure I have done it earlier....:0

I want to create a RLS filter saying for example:

Department IN ('Dep A' 'Dep B' 'DepC')

But the IN operator is not available to me.

I have tried it both in the admin interface by clicking and by using the batch tools, but only get an error message saying the IN operator is unknown...

The only operators I can use are:

Any ideas???

//Fredrik

Re: SAS Visual analytics 7.4 Row level security - I'm not able to use the "IN" operator

KianSin — Fri, 26 Oct 2018 10:29:10 GMT

Hi Fredrick,

Try this out, http://support.sas.com/kb/57/753.html

If it still doesn’t work, then it worth opening a support track with SAS.
Cheers.

KianSin

Re: SAS Visual analytics 7.4 Row level security - I'm not able to use the "IN" operator

FredrikE — Fri, 26 Oct 2018 10:49:21 GMT

Thanks, I will try it again!

I have used the batch tool and got the same error, but maybe I did some kind of typo....:)

The story coninues...

//Fredrik

Re: SAS Visual analytics 7.4 Row level security - I'm not able to use the "IN" operator

FredrikE — Fri, 26 Oct 2018 12:16:22 GMT

It worked indeed 🙂 !!!!

Must have made something wrong in my first try, thanx again!

//Fredrik