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."
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.