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!
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.
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.