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
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 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | alert |
Date Modified: | 2016-05-09 09:30:14 |
Date Created: | 2016-03-09 12:20:10 |