I would like to ask if would you know if there's a function to determine the user-group in sas visual analytics data preparation?
For additional information. Our requirement is to display the Department or Branch in just 1 Bar Graph as Category. Let say if the User is under Department Group the graph should display Department data only, if user is under Branch Group the graph display Branch data only. Thank you in advance.
Have you considered using row-level security on the underlying table and to achieve what you're after? Have a look at the paper, http://support.sas.com/resources/papers/proceedings15/SAS1779-2015.pdf which may provide you some ideas on how you can use row-level security to subset the data. To meet your requirements for your bar chart, you could have a new computed column that is based on conditional logic within your data - depends on the structure of your data.
//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com
Thank you for quick response. Yes, we already applied the row-level security and we already have the copy of SAS1779-2015. If we add computed column as conditional logic it is too long as we have many Users and I believe the data preparation expression has a limited length only. The reason why I am looking for function to determine the user-group is to lessen the length of expression. Thanks again.
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.