The multi-select properties in a SAS^® Campaign Studio multi-select node allow you to choose fields which are to be included. Once a field is selected, you can then choose which values of that field are to be used when building the query from the Select Values dialog box.

If the field has an asscoiated list of values, then these are presented and you can select which are required. If no list is present, then you can enter individual values to create a list.

Once it is accepted, the application then returns to the Multi-select Properties dialog box and enables you to select more fields and generate counts. A certain set of circumstances, however, causes a zero count to be produced when, in fact, the count is not zero.

If after creating a list of values, the multi-select node is closed and re-opened and you change the values of the selection list in the Multi-select Properties dialog box rather than in the Select Values dialog box, then the counts will be returned as zero.

This is because the underlying SQL will change from:

to:

To work around this problem, change the list values in the Select Values dialog box and not in the Multi-select Properties dialog box.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Marketing Automation 4.4 is available at:

A fix for this issue for SAS Marketing Automation 5.1 is available at: