topic Function in Data Preparation to determine the user group in SAS Visual Analytics

Function in Data Preparation to determine the user group

Carrot17 — Wed, 01 Jun 2016 01:53:49 GMT

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

Re: Function in Data Preparation to determine the user group

MichelleHomes — Wed, 01 Jun 2016 02:08:15 GMT

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

Re: Function in Data Preparation to determine the user group

Carrot17 — Wed, 01 Jun 2016 02:37:44 GMT

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