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

/******************************************************************************/
/* 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;

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