We recently upgraded Visual Analytics to 7.5 and I'm testing out the software. I have a previous exploration that is now a report. I'm trying to assign parameters to a 3 drop-down lists. Eventually I need the drop down boxes to filter the selections of each other.
I have 3 parameters (Selected Commodity, Selected Plant-Line, Selected Year) defined. In none of the drop down lists will it allow me to assign a parameter to the parameter role. Two of the list boxes have numeric values and 1 has category. I have the parameters created to match.
I've tried the list box inside a prompt container and not.
I cannot figure out the secret handshake for it to allow me to assign a parameter to a drop-down list.
Thanks
The drop-down list enables you to add numeric parameters only when the Category role uses a numeric data item that has been converted to a category, making the value a discrete numeric value:
I don't know why you would not be able to select a character parameter for the dropdown list. What do you have assigned to the Category role?
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
Drop-down List 1 uses a Numeric variable classified as a Category.
Drop-down List 2 uses a Date/time variable formatted as Year and classified as a Category
Drop-down List 3 uses Character variable classified as a Category
In each of the lists I have Frequency chosen as a measure.
The drop-down lists themselves work. I have them in a prompt container on the Report.
I have 3 parameters defined, 2 as Measures and 1 as a Category.
When I click Add on Parameter, the Add Data Item opens but says "No data items available for role."
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 25. 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.