If you create an interface definition in the SAS Campaign Management
component, and select the Ordering tab, you cannot change the Order By
field to 'Descending'.  This option displays 'Ascending' by default,
and the pick list which used to allow you to select 'Descending' is no
longer there.

The following steps may allow you to work around the problem:

  1. Set up an export definition and change the Index value for all
     fields from tables with a one-to-many relationship to the root
     from '1' to 'n/a'.  This removes all entries from the Order tab.

  2. Save this definition.

  3. Edit the export definition and change the Index values back to '1'
     from 'n/a' on the Fields tab.

  4. Now the Ordering tab contains the field entry for the one-to-many
     table, and you can access the drop down box containing the
     'Ascending' and 'Descending' choices.

  5. If you make a change and then save the definition, the only way you
     can alter the 'Ascending' or 'Descending' option again is to change
     the Index value from '1' to 'n/a' on the Fields tab.


A Technical Support hot fix for this issue is available at:
http://ftp.sas.com/techsup/download/hotfix/cam75.html

Operating System and Release Information

A fix for this issue for Campaign Management Component 7.5 is available at: