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!
