The SAS^® Revenue Optimization Load_STG2DM_Sales_mix_day_of_week job does not validate the values in the STG_SALES_MIX_DAY_OF_WEEK.DOW_MIX_INDEX column before loading them into the DI_DM.SALES_MIX_DAY_OF_WEEK table. The value of STG_SALES_MIX_DAY_OF_WEEK.DOW_MIX_INDEX should be between 0 and 1. The Load_STG2DM_Sales_mix_day_of_week job does not reject records where the value is less than 0 or greater than 1.

If incorrect values are loaded into the DI_DM.SALES_MIX_DAY_OF_WEEK table, then send in new STG_SALES_MIX_DAY_OF_WEEK records for each GEO_ID, PROD_ID, and DAY_OF_WEEK combination with the correct DOW_MIX_INDEX values and the CHANGE_FLG set to 'U'. This updates the records with the correct values.

Operating System and Release Information