Problem Note 57821: The Load_STG2DM_Geo_prod_price_fact job might not load expected records into the partition PRICE_FACT_FUTURE table
 |  |  |  |  |
The SAS® Revenue Optimization Load_STG2DM_Geo_prod_price_fact job might not load expected records into a partition PRICE_FACT_FUTURE table. When a product has multiple locations that have the same values for REGULAR_PRICE, ACTUAL_PRICE and PRICE_TYPE in both the PRICE_FACT_FUTURE and STG_GEO_PROD_PRICE files, only the first location might be loaded into the PRICE_FACT_FUTURE table.
The following example shows what happens when data is loaded for the week ending 27FEB2016.
Partition PRICE_FACT_FUTURE table before running the Load_STG2DM_Geo_prod_price_fact job:
| PROD_ID | GEO_ID | VALID_FROM_DT | VALID_TO_DT | REGULAR_PRICE | ACTUAL_PRICE | PRICE_TYPE |
|---|---|---|---|---|---|---|
| PROD_A | STORE_01 | 24FEB2016 | 31DEC5199 | 6 | 3 | 3 |
| PROD_A | STORE_02 | 24FEB2016 | 31DEC5199 | 6 | 3 | 3 |
DIDM_STG.STG_GEO_PROD_PRICE:
| PROD_ID | GEO_ID | EFFECTIVE_DT | REGULAR_PRICE | ACTUAL_PERM_PRICE |
|---|---|---|---|---|
| PROD_A | STORE_01 | 02MAR2016 | 6 | 3 |
| PROD_A | STORE_02 | 02MAR2016 | 6 | 3 |
Partition PRICE_FACT_FUTURE table after the Load_STG2DM_Geo_prod_price_fact job has run:
| PROD_ID | GEO_ID | VALID_FROM_DT | VALID_TO_DT | REGULAR_PRICE | ACTUAL_PRICE | PRICE_TYPE |
|---|---|---|---|---|---|---|
| PROD_A | STORE_01 | 02MAR2016 | 31DEC5199 | 6 | 3 | 3 |
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Retail Forecasting | Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.3 TS1M0 |
| Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.3 TS1M0 | ||
| SAS System | SAS Regular Price Optimization | Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.3 TS1M2 |
| Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| SAS System | SAS Promotion Optimization | Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.3 TS1M2 |
| Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| SAS System | SAS Markdown Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
A fix for this issue for SAS Revenue Optimization 5.2_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/P20.html#57821A fix for this issue for SAS Size Optimization 3.2_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/P21.html#57821| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2016-05-09 09:30:14 |
| Date Created: | 2016-03-09 12:20:10 |