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?
Hey @Sigord! From your description, it sounds like you're doing this:
Can you confirm if the parameter is being set to a value when the report is opened? If not, this would cause 'year'p to initially not start off with a value.
Since both data sources share Year, have you tried mapping Year from data source 1 to Year in data source 2? That way you can avoid a parameter-based solution.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.