BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Rupasree
Obsidian | Level 7

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

1 ACCEPTED SOLUTION

Accepted Solutions
Rupasree
Obsidian | Level 7

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

3 REPLIES 3
LinusH
Tourmaline | Level 20

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

Data never sleeps
Rupasree
Obsidian | Level 7

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
Quartz | Level 8

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: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 3 replies
  • 2316 views
  • 2 likes
  • 3 in conversation