Problem Note 32554: Only one response is reported when multiple treatments share the same response code
When multiple SAS® Customer Intelligence treatments share the same treatment code, then only one of them is reported.
This is because the Treatment_sk column in the SAS Customer Inteligence Common Data Model CI_RESPONSE_HISTORY table needs to be included as part of table's primary key.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Once you have installed the hot fix, but before running the DDL update scripts supplied with the hot fix to alter the CI_RESPONSE_HISTORY tables, run attached SQL. (This is also discussed in the hot-fix installation documentation.) Running the SQL is necessary because when there is no treatment information associated with existing responses, the treatment_sk column will be set to NULL, a value that is not permitted in a primary key.
Operating System and Release Information
| SAS System | SAS Customer Intelligence Processes | Microsoft® Windows® for x64 | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows 2000 Advanced Server | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows 2000 Datacenter Server | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows 2000 Server | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows 2000 Professional | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows NT Workstation | 5.1 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Standard Edition | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows XP Professional | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Windows Vista | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| 64-bit Enabled AIX | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| 64-bit Enabled HP-UX | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| 64-bit Enabled Solaris | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| HP-UX IPF | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Linux | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
*
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.
This code will ensure that no NULL values remain in TREATMENT_SK field before it is incorporated into the the CI_RESPONSE_HISTORY table primary key.
/******************************************************************************/
/* 51MA01 Migration script for the CI hot fix defect */
/* */
/* S0476735: UPDATE RESPONSE: MULTIPLE TREATMENTS SAME RESPONSE CODE: */
/* ONE GETSIN CICOMORA.CI_CUST_RESP_HIST */
/* */
/* Prior to executing this script please make the following changes: */
/* a) Supply the complete libname statement to rptlib macro variable */
/* (libname statement where the CI Common model is installed) */
/* */
/* b) Supply the Response_History table name */
/* if the customer site has more than one Response_History table i.e. */
/* one table per subject, then provide the table name for one subject at a */
/* time and execute this script. Repeat this process to update all */
/* subject specific response history tables */
/* */
/******************************************************************************/
%let rptlib=<>;
%let rh_tbl=<>;
&rptlib;
%let libnm = %upcase(%qscan(&rptlib.,2));
proc sql;
update &libnm..&rh_tbl.
set TREATMENT_SK=-1
where TREATMENT_SK IS NULL;
quit;
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2008-07-01 10:59:59 |
| Date Created: | 2008-06-25 14:53:55 |
