Hi Teri,

You seem to have a pretty firm grasp on how parameters work in VA so I'm hoping you might be able to address this.

I want to pass a single piece of data (say latest date OR most popular item in the office fruit bowl this week) to Visual Analytics (Designer) and use this in calculated items for various tables and filters in various objects.

To do this by I've created a SAS table with a single row and single column (called say 'fruit' with value 'Orange') and loaded this to VA

If I create a parameter associated with the data item 'fruit' or associated with a Control Object (Drop-Down List or button Bar with the category being 'fruit') and then create calculated items/filters as required all works fine.

The problem comes if the table is repopulated with 'fruit' value 'Apple' and reloaded to VA. The parameter value does not update. I have check the 'Required' box for both of the controls and the Button Bar even shows the single possible value but it is light-gray (unselected) i.e.'Required' is not forcing selection.

The logic seems to be that the value of the data item has not been (re-)selected so the parameter is not updated.

Do you know any way to make this work as I'm intending or know any other way to address the problem.

Many thanks in advance,

Alan Whiting
Ministry of Business, Innovation and Employment
New Zealand