How Do I Implement Conditional Grants on Multiple Table Columns in SAS Visual Analytics?

[Carrot17]

Hi Everyone,

I have come across this blog post from Michelle: https://www.metacoda.com/en/2014/01/conditional-grants-sas-visual-analytics/ which I found useful in implementing Row-Level Security.

I just need some help in tweaking the method in a way that allows different group of users to see different data from the other. This is more on the hierarchy of the user groups. Let's say we have  two different columns from our table, namely: Group, and Department. Then we have two user groups that accesses the exploration, for example Group Heads and Department Heads. Each user in the Group Heads user group accesses data based on the column Group, whilst Department Heads acccesses based on Department. The thing now is that the data for the Group Heads should show the data item value from Group column, while the Deapartment shows the data item value from Department column.

Is there a way to implement this on a single exploration to show the data from either of the two columns (data items) based on the user group the current user belongs to? By the way, I am using SAS VA 7.1.

Thanks,

Carrot17

[MichelleHomes]

Hi Carrot17,

I'm pleased to hear you found the blog post useful.

To set up row-level security for groups of users, it is best to refer to page 40 in the VA 7.1 SAS Visual Analytics Administration Guide (you'll need the userid and password from SAS Technical Support) which explains how to do this in batch. There has also been discussions on this in a separate thread you may find helpful, https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-IdentityGroups-in-Conditional-Grants/m-p/196...

Hope this helps.

Kind Regards,

Michelle