topic Re: SAS VA 7.5 Drop-down box won't allow parameters in SAS Visual Analytics

SAS VA 7.5 Drop-down box won't allow parameters

AJRowe — Mon, 05 Oct 2020 22:29:00 GMT

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

Re: SAS VA 7.5 Drop-down box won't allow parameters

Madelyn_SAS — Tue, 06 Oct 2020 14:34:24 GMT

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:

The button bar control or drop-down list control accepts a character parameter, a datetime parameter, or a numeric parameter if a discrete numeric data item is assigned.

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?

Re: SAS VA 7.5 Drop-down box won't allow parameters

AJRowe — Tue, 06 Oct 2020 17:15:22 GMT

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."