I have a SAS VA report with a prompt that has many multi-select list objects. It is imperative that the users of the report have the ability to save their selection so that they can reopen the report with their previous selections already filtered.
I know it is possible to use parameters for single-selection objects and build a URL that will select filter the report. My current report uses only multi-select objects which do not allow for parameters.
We have currently thought of some (poor) workarounds for this problem.
Give users access to the development server and have them save their report selections as entirely new report files.
Capture user preferences in another application. Save these to a database and give them a label. Create a new column in the dataset that tags each row with the label name. In SAS VA, use a single dropdown selection to select this label.
All three of these ideas seem terrible to me. I was wondering what others have done to save user selections.
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.