Problem Note 11545: When defining filters some of the tables to map to are not available in
the drop down list
In the Define Filter window of the SAS Campaign Management component,
some of the tables to map to do not appear in the drop down list.
Tables which have compound keys that are defined in the ISMFLDCT
metadata table with a lower RECSEQ value than the tables with simple
keys do not display in the list.
To circumvent the problem, you must change the RECSEQ values in ISMDBSTR
for all records for tables that have compound keys. You should set the
value of RECSEQ for these records to be larger than 9000 in order to
force all the affected tables to be sorted to the end of the list and
consequently become available for selection when defining filters.
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
| SAS System | SAS Campaign Management | Microsoft Windows NT Workstation | 7.5 | | | |
| Microsoft Windows XP Professional | 7.5 | | | |
| Microsoft Windows 2000 Professional | 7.5 | | | |
| Microsoft Windows 2000 Advanced Server | 7.5 | | | |
| Microsoft Windows 2000 Server | 7.5 | | | |
| Microsoft Windows 2000 Datacenter Server | 7.5 | | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2004-02-23 15:22:04 |
| Date Created: | 2004-01-07 08:55:57 |
