Problem Note 45546: Spend values for low-owned products might be incorrect
When you view the spend values for low-owned inventory products in the SAS® High Performance Markdown Optimization Client, you might have incorrect values.
This error occurs because the GEO_PROD_OWNED_INV table is not correctly partitioned. The DI_DM.GEO_PROD_OWNED_INV table has the correct data, but the partition level GEO_PROD_OWNED_INV tables are incorrect.
To workaround this issue perform the following steps. All steps need to be performed in a SAS environment with the Merchandise Intelligence libraries allocated.
- Run the macro %di_util_purge_deleted_records(DI_DM.GEO_PROD_OWNED_INV)
- Run the %TKMI_JOB_RO partition_dm_hier_1 task
- On a multi-machine environment run %TKMI_JOB_RO copyDataToCaptains_service
- Run weekly batch optimization
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS High-Performance Markdown Optimization | Linux for x64 | 4.3_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
*
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: | medium |
| Date Modified: | 2012-02-01 13:34:59 |
| Date Created: | 2012-01-31 14:30:21 |
