I work in SAS VA 7.5 and use two data sources in my dashboard. To filter the values in the second auxiliary data source, I use the year parameter that I get from the drop-down list based on the first main data source. I then use this parameter in the advanced filtering formula. This works fine in edit mode, but in view mode it only works for the values that were selected when the dashboard was saved. If I change the year in view mode the second auxiliary data source is empty. How can this be fixed?
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.