Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Function in Data Preparation to determine the user group

Reply
Contributor
Posts: 54

Function in Data Preparation to determine the user group

Hi,

 

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.

 

 

Best Regards,

Carrot17

 

Trusted Advisor
Posts: 1,296

Re: Function in Data Preparation to determine the user group

Hi @Carrot17,

 

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.

 

Kind Regards,

Michelle

Contributor
Posts: 54

Re: Function in Data Preparation to determine the user group

[ Edited ]

Hi @MichelleHomes,

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.


Best Regards,
Carrot17

Ask a Question
Discussion stats
  • 2 replies
  • 199 views
  • 0 likes
  • 2 in conversation