topic Filter using Logged In User in SAS Visual Analytics

Filter using Logged In User

balraj — Mon, 04 Apr 2016 08:58:22 GMT

Hi Community,

I got a requirement wherein the data for a "BarChart" should be filtered based on the "Logged In User". How can I implement this in SAS Report Designer.

Kind Regards,

Balraj

Re: Filter using Logged In User

JuanS_OCS — Mon, 04 Apr 2016 09:01:55 GMT

Hi,

I wonder if what you are looking for is the “Row level security” in SAS Visual Analytics.

http://support.sas.com/resources/papers/proceedings15/SAS1779-2015.pdf

http://support.sas.com/documentation/cdl/en/vaug/65747/HTML/default/viewer.htm#n1reswjzgl7gjyn1iio6mcp88c9y.htm

Best regards,

Juan

Re: Filter using Logged In User

MichelleHomes — Mon, 04 Apr 2016 09:08:07 GMT

Hi Balraj,

It seems that to fulfill your requirement you may need to do row level security. Have a look at this search criteria on row level security to see if these threads help answer your question. If not, please elaborate further on what it is that you are trying to achieve with the filter. What is being filtered and is it for every user etc.

Kind Regards,

Michelle

Re: Filter using Logged In User

balraj — Mon, 04 Apr 2016 09:48:25 GMT

Hi @MichelleHomes and @JuanS_OCS

I got an output table from Databuilder with data for all the users. When the user logs in he should be able to see the data related to his own region/country. I've implemented row level security as suggested by @JuanS_OCS its working but I need to use the Logged in user to filter the data either to the Report Object such as bar,table,crosstab or to the Output table.

I'm following this link for passing the username but unable to get the expected result.

i.e. Identity-Driven Properties

http://support.sas.com/documentation/cdl/en/bisecag/67045/HTML/default/viewer.htm#n0m3ptctbmjpzkn1woe49pep6tep.htm

If you can guide me on how i can use Identity-Driven Properties either in Report Designer/DataBuilder that will be great. 🙂

Kind Regards,

Balraj

Re: Filter using Logged In User

nattargekar — Wed, 13 Apr 2016 07:11:54 GMT

Hi @JuanS_OCS, @MichelleHomes and @balraj,

Even I am trying to use logged in user name to filter out data the way @balraj was trying. If it's required to use batch tools to apply Identity driven filtering, can you please put some light on how to use it in batch tools? Can we do it without using batch tools? I mean, in data builder or at report designer level ? Will appreciate the reply.

Re: Filter using Logged In User

MichelleHomes — Wed, 13 Apr 2016 09:38:00 GMT

Hi @nattargekar,

If you are looking for a point and click way to do this, the blog I wrote, Conditional Grants in SAS Visual Analytics may help. You need to use SAS Visual Analytics Administrator for this technique. There isn't a way to do set up row-level security within SAS Visual Analytics Designer.

Kind Regards,

Michelle

Re: Filter using Logged In User

nattargekar — Fri, 15 Apr 2016 07:19:54 GMT

Hi @MichelleHomes, Thank you very much for your reply. Yes I have gone through the blog you wrote on metacoda. It was helpful.

I was also wondering to use -condition "empID='SUB::SAS.Userid'" to find out the logged in user and apply identity specific filtering. I don't know where to use it. I tried it in query designer and report designer expressions but I doubt It is not the correct place to use it. Can you give an example of it and how to use it (I think in command prompt with batch tools, am I right ?). I am new to SAS VA. Your valueable reply will be very helpful. Thank You.

Re: Filter using Logged In User

MichelleHomes — Fri, 15 Apr 2016 10:32:57 GMT

Hi @nattargekar,

Your assumption in using the batch tools is correct. You may want to look at this thread that outlines it well. https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-IdentityGroups-in-Conditional-Grants/m-p/196343#M1617

Kind Regards,
Michelle

Re: Filter using Logged In User

balraj — Mon, 18 Apr 2016 07:56:55 GMT

Hi @MichelleHomes , @JuanS_OCS Thanks alot for you guidance

I've Successfully implemented it, summing up all the steps:

1. Goto "C:\Program Files\SASHome\SASPlatformObjectFramework\9.4\tools"

2. Open the command prompt and navigate to the above path

3. Enter the below statement, here object-path refers to the path to LASR TABLE. If it is a Table Object append the path with (Table) else not required.

sas-set-metadata-access -host <hostname> -port < portno> -user <username>-password <password>    
"< object-path>" -grant "<group>":Read,ReadMetadata -condition "(<colname>) IN ('SUB::SAS.IdentityName')"

4. Refer below URL's for reference.

Batch Tools for Metadata Authorization

Batch tool sas-set-metadata-access

Identity-Driven Properties

Re: Filter using Logged In User

MichelleHomes — Mon, 18 Apr 2016 14:29:02 GMT

Hi @balraj,

Glad to hear you have it working and thanks for sharing the steps for your implementation that may help others in future.

Kind Regards,

Michelle

Re: Filter using Logged In User

MG18 — Mon, 27 Feb 2017 10:27:48 GMT

Hi ,

Is this possible in Stored process, I want to add same functionality in Stored Process.

If user sademo logged in the filter should be come for sasdemo only. Is this possible ?