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-2024.png

📢

ANNOUNCEMENT

The early bird rate has been extended! Register by March 18 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

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
  • 1920 views
  • 2 likes
  • 3 in conversation