In SAS® Size Profiling, the %DI_JOB_RO MODEL_GP_STATUS task might eliminate large amounts of sales data when sales occur in only one week. This issue occurs because the task currently eliminates single weeks of selling data for sizes at a store in order to exclude unintended sizes from becoming active.  This could happen, for example, when an e-commerce-only size is returned to a store and later sold there.   However, the task currently does not consider the quantity of units sold before it eliminates the week(s) of sales.   Thus, if a store has large sales all in a single week, these sales are eliminated from the active period.  

There is no workaround for this issue.

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

After the fix is available, there are two changes:

1. A new parameter called mgps_sales_unit_threshold is added to the PRF_CONFIG table.
2. An additional setting for the Prf_config mgps_activate_all_size setting in the PRF_CONFIG file is enabled.

The new parameter called mgps_sales_unit_threshold acts as a threshold for the number of sales in a single week to be included in active period.  Single week selling is eliminated only if the amount of sales units for that store-week-size is less than the threshold. 

If the threshold value is: 

• Null, then no threshold test is done, and the solution works the same way as before fix. 
• Zero, then no data is excluded.   All sales weeks regardless of quantity could trigger an active period. 
• Greater than 0, then the threshold is just that.  For example, if the threshold is set to 2, that week of sales is preserved if there are 2 or more units sold. 

In addition, the mgps_activate_all_size setting in the PRF_CONFIG file might also need to change. The fix introduces a new option, '3', which results in only the individual stores with sales in a size having active records for just those sizes. No other sizes or stores are activated. 

Possible values:

0 = Activate only the sizes that had sales at the specified store.

1 = Activate all sizes when any size of the style-color has a sale at that store.

2 = Activate the sizes in all stores when a SKU has a sale at any store.

3 = Activate only sizes that had sales at a specified store for only for those weeks that had sales.  This results in sizes that have different active periods in the same store.

Operating System and Release Information

A fix for this issue for SAS Size Optimization 3.41_M2 is available at:

A fix for this issue for SAS Size Optimization 3.41 is available at:

A fix for this issue for SAS Revenue Optimization 5.4 is available at:

A fix for this issue for SAS Size Optimization 3.4 is available at:

A fix for this issue for SAS Revenue Optimization 5.2_M4 is available at: