If you are optimizing plans in SAS^® Revenue Optimization Suite, plans might fail optimization due to missing INT values in the price promo elasticity table.

To determine whether this is the cause of the optimization error, run the following code to extract the price promo elasticity table. Replace the prod_hier_sk and geo_hier_sk values 1111, 1123, and 89 with the prod_hier_sk and geo_hier_sk values for the plan that you are optimizing.

proc printto log="location where you want the log to be written"
      new; 
   quit;

%let syscc=0;

data gp_filter;
   set diconcat.model_geo_prod;
   where prod_hier_sk in (1111, 1123) and geo_hier_sk in (89);
   run;

%di_dm_forecast_extract( data_lib= diconcat,
                         process_lib= work,
                         gp_filter_table= gp_filter,
                         _base_forecast_table = bf,
                         _sales_forecast_table= sf,
                         _price_promo_elasticity_table= ppe);

Open the ppe table. If the INT values are missing, then this problem occurred.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Merchandise Intelligence 3.2 is available at: