Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Row Level Security IN VA Report

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 9
Accepted Solution

Row Level Security IN VA Report

[ Edited ]

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:Smiley FrustratedAS.PersonName') AND (((Flag=1) AND ('SUB:Smiley FrustratedAS.IdentityGroups' Contains 'GroupA')) OR

((Flag=0) AND ('SUB:Smiley FrustratedAS.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:Smiley FrustratedAS.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


Accepted Solutions
Solution
‎04-18-2016 10:23 AM
Occasional Contributor
Posts: 9

Re: Row Level Security IN VA Report

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

View solution in original post


All Replies
Esteemed Advisor
Posts: 5,092

Re: Row Level Security IN VA Report

[ Edited ]

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

Data never sleeps
Solution
‎04-18-2016 10:23 AM
Occasional Contributor
Posts: 9

Re: Row Level Security IN VA Report

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

Contributor
Posts: 71

Re: Row Level Security IN VA Report

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

Post a Question
Discussion Stats
  • 3 replies
  • 445 views
  • 2 likes
  • 3 in conversation