Hi,
Anyone knows getting the Group or Role and set the conditional in Report Designer level is posible?
Let say, In Report Designer I created a Calculated Item where the conditionl is if your role is Branch Manager you can only see the Branch Name else if the role is Department Manager can only see the Department name.
Thanks and Have a great day!
Best Regards,
Carrot17
Hi @Carrot17,
You can set up row level security using the SAS Visual Analytics Administrator or in batch on groups. It isn't possible to create it within Visual Analytics Report Designer on a calculated data item.
Check out this Row Level Security and SAS Visual Analytics 2015 SAS Global Forum Paper that describes both methods. There is also information on this in the SAS Visual Analytics Administrator Guide.
Kind Regards,
Michelle
My pleasure. If the question has been answered to your satisfaction, please mark it as solved.
Kind Regards,
Michelle
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.