Problem Note 54738: Performance in SAS® Promotion Optimization might be slow when loading promotions that include vendor deals
In SAS Promotion Optimization, performance might be slow when loading promotions that include vendor deals. Slow performance might be observed in the Promotion List view and the Promotion Details view. The slow performance occurs because of a missing index for the RPP_VENDOR_DEAL table.
The workaround for this issue is to add the missing index by running the code below in a SAS session where the MI libraries are allocated:
%let m_sql_statement = %str( create index RPP_VENDOR_DEAL_IX5 on RPP_VENDOR_DEAL (abs(PLAN_SK)) );
%di_dm_trans_exe(pass_through_sql=%quote(&m_sql_statement),session_flg=1);
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Promotion Optimization | Linux for x64 | 5.2 | 5.4 | 9.3 TS1M1 | 9.4 TS1M3 |
Microsoft® Windows® for x64 | 5.2 | 5.4 | 9.3 TS1M1 | 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: | high |
Date Modified: | 2015-04-14 09:44:28 |
Date Created: | 2014-12-01 09:32:13 |