Row Level Security IN VA Report

[Rupasree]

Hi All,

We have a requirement ,where we need to restrict the rows based on the group of the user logged i.e. if the user A has logged on to access the report and if he belongs to group "GroupA" then he will be allowed see the data where Flag=1 in the chart or else he will see the data where Flag=0.

To achieve the same, i have written the below rule to authorise the data:

('UID'n = 'SUB::SAS.PersonName') AND (((Flag=1) AND ('SUB::SAS.IdentityGroups' Contains 'GroupA')) OR

((Flag=0) AND ('SUB::SAS.IdentityGroups' NotContains 'GroupA')) )

But, the chart throws an error with Invalid Data.

I changed the rule to figure out where is the error :

('UID'n = 'SUB::SAS.PersonName') AND ((Flag=1) OR (Flag=0))

With the modified rule data is displayed in the chart though not the correct data but without any error.

Please help us to figure out the error in the above rule.

Your help is highly appreciated.

Regards,

Rupasree

[LinusH]

Seems to be a missing space between Not and Contains. Just in the post?

[Rupasree · Accepted solution]

Hi All,

The above issue was solved by using sas-metadata-access batch tool.The below link gives more information about batch tool:

http://support.sas.com/resources/papers/proceedings15/SAS1779-2015.pdf

Regards,

Rupasree

[balraj]

Hi @Rupasree

Thanks for your reply, I've successfully implemented it. Check this link

https://communities.sas.com/t5/SAS-Visual-Analytics/Filter-using-Logged-In-User/m-p/264493#M3925

Kind Regards,

Balraj