https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-filter-data-based-on-the-USERID-the-user-logs-in-with/m-p/945608#M18358 <P>Thanks for this, so is there no way to do it at the report level? It appears I don't have access to Manage Environment in SAS VA</P> Sun, 29 Sep 2024 19:09:17 GMT SteveNZ 2024-09-29T19:09:17Z https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-filter-data-based-on-the-USERID-the-user-logs-in-with/m-p/945136#M18350 <P>We have a number of dashboards that contain sensitive data. In each separate piece of data we have a Usercode variable which is the same the user uses to log in with.</P> <P>&nbsp;</P> <P>Is there a way to automatically filter the data based on their login matching the Usercode variable?</P> <P>&nbsp;</P> <P>Many thanks in advance!</P> Wed, 25 Sep 2024 04:17:29 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-filter-data-based-on-the-USERID-the-user-logs-in-with/m-p/945136#M18350 SteveNZ 2024-09-25T04:17:29Z https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-filter-data-based-on-the-USERID-the-user-logs-in-with/m-p/945143#M18351 <P>Some starting points:</P> <P><A href="https://documentation.sas.com/doc/en/vacdc/7.5/vaag/n0hopehj2j9vzun1jm9rl56bpnrh.htm" target="_blank">SAS Help Center: Row-Level Security</A></P> <P><A href="https://communities.sas.com/t5/SAS-Communities-Library/Examples-of-row-level-security-in-SAS-Viya/ta-p/578700" target="_blank">Examples of row-level security in SAS Viya - SAS Support Communities</A></P> Wed, 25 Sep 2024 06:11:09 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-filter-data-based-on-the-USERID-the-user-logs-in-with/m-p/945143#M18351 LinusH 2024-09-25T06:11:09Z https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-filter-data-based-on-the-USERID-the-user-logs-in-with/m-p/945608#M18358 <P>Thanks for this, so is there no way to do it at the report level? It appears I don't have access to Manage Environment in SAS VA</P> Sun, 29 Sep 2024 19:09:17 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-filter-data-based-on-the-USERID-the-user-logs-in-with/m-p/945608#M18358 SteveNZ 2024-09-29T19:09:17Z https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-filter-data-based-on-the-USERID-the-user-logs-in-with/m-p/945635#M18359 Don't know, but if the secrecy of your data is important, permissions should be enforced on the data level, not in individual reports. Mon, 30 Sep 2024 07:44:12 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-filter-data-based-on-the-USERID-the-user-logs-in-with/m-p/945635#M18359 LinusH 2024-09-30T07:44:12Z https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-filter-data-based-on-the-USERID-the-user-logs-in-with/m-p/945713#M18372 <P>Prefiltering the data based on user ID is done at the data source level. You cannot do that in the report. If you don't have admin access to Manage Environment, then an administrator would need to apply the filter for you.&nbsp;</P> Mon, 30 Sep 2024 17:13:11 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-filter-data-based-on-the-USERID-the-user-logs-in-with/m-p/945713#M18372 Madelyn_SAS 2024-09-30T17:13:11Z https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-filter-data-based-on-the-USERID-the-user-logs-in-with/m-p/945716#M18373 <P>Thanks all, I'll get in touch with the admins and go from there. If anyone from SAS monitors this it would be a good feature if a user could put the filter on at the data source level when you add it to a report.&nbsp;</P> Mon, 30 Sep 2024 18:58:06 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-filter-data-based-on-the-USERID-the-user-logs-in-with/m-p/945716#M18373 SteveNZ 2024-09-30T18:58:06Z