When you install the SAS^® Revenue Optimization Suite, the DI_DM2.PURGE_QUERY table is populated with default values. The default PURGE_ORDER values for the GEO_PROD and GEO_PROD_STATUS tables are incorrect.

To correct the PURGE_ORDER values, run the following PROC SQL code in a SAS session where the SAS® Merchandise Intelligence libraries have been allocated:

proc sql;
update di_dm2.purge_query
   set purge_order = 12
   where table_nm = 'GEO_PROD';

update di_dm2.purge_query
   set purge_order = 13
   where table_nm = 'GEO_PROD_STATUS';
quit;
run;

Operating System and Release Information