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
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
Seems to be a missing space between Not and Contains. Just in the post?
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
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
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.