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."
Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.
Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.
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.