How to Filter by Logged-In User in SAS Visual Analytics (SAS Viya 4)

[yf_nf]

Hi everyone, In SAS Studio, I can retrieve the currently logged-in user using &SYSUSERID.

In SAS Visual Analytics (VA) on SAS Viya 4, I’m trying to achieve something similar. I have a dataset with a column named "user" that contains usernames. I want to filter this dataset within a VA report so that each user sees only the row(s) corresponding to their username.

I tried applying a data filter using the following expressions:

• user = 'SUB::SAS.Userid'
• UpCase(user) = UpCase('SUB::SAS.Userid')

However, in both cases, the filter returns 0 rows, even though the "user" column contains the exact username of the account I'm using to connect to the report.

How can I dynamically filter the data in SAS VA to show only the rows for the current logged-in user?

Thanks in advance for any guidance!

[EyalGonen]

Hi @yf_nf 

Make sure your "user" column matches the ID of the requested username. You can visually see the User ID in SAS Environment Manager when you view the properties of the user.

If this is correct, try, as an alternative, to set the Conditional Grant permission on the CAS table itself. See if that works for you.