Hi all VA experts 🙂
I'm not sure this problem can be solved, but maybe someone of you already deal with it and has found some workaround 😉
We have a report in VA 7.3 (but the same applied to VA 6.4) with a dropdown menu used as a mandatory filter for a field (we can say it is country, i.e.). The filter is mandatory since data cannot be aggregate in a grand total manner.
On the same field of the table we have also a row level security applied, since some users can see all the countries, some other just some of them, and some other again just one.
At this point, when we save the report the filter menu has a value in it, lets say USA. But now, if a user that has only available Europe as country try to open the report, it has a no data available, since the report try to apply the USA filter to the data, that has only Europe available.
Is there a way solve or workaround this behaviour?
Thanks all 🙂
Thanks for the suggestion. I was hoping in something less tricky, but I see there are no other advice 🙂
We will try to find out if can do something like this in our case 🙂
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.