SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 50216: The Minimum Weeks Between Markdowns rule is violated when midweek markdowns are present

DetailsHotfixAboutRate It

Markdown recommendations in SAS® Markdown Optimization or SAS® High-Performance Markdown Optimization might violate the Minimum Weeks Between Markdowns rule. A markdown might be recommended in a week where there should not be a markdown allowed because there have not been a sufficient number of weeks after the previous markdown.

This issue occurs when markdowns meet all three conditions:

  • occur outside of SAS Markdown Optimization or SAS High-Performance Markdown Optimization
  • occur in the past n weeks where n is the minimum number of weeks between markdowns
  • are sent to the system via ETL as price facts effective midweek instead of on a system defined weekly boundary

The effect is different depending on when the midweek markdown occurred.

  • If the midweek markdown occurred last week (the week before the current week), then optimization incorrectly allows a markdown in any week after the frozen week.
  • If the midweek markdown occurred in any week before last week up to the current week - n, then optimization incorrectly allows more than n weeks between markdowns. Optimization incorrectly considers the markdown in the week after it occurred.

To work around this issue, do not load markdowns effective midweek. Load only those markdowns whose effective dates correspond to the system-defined weekly boundaries.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS High-Performance Markdown OptimizationMicrosoft® Windows® for x644.3_M29.2 TS2M3
Linux for x644.3_M29.2 TS2M3
SAS SystemSAS Markdown OptimizationMicrosoft® Windows® for x645.25.2_M39.3 TS1M29.3 TS1M2
Linux for x645.25.2_M39.3 TS1M29.3 TS1M2
* 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.