Show TOC

 Intra-week Pattern

 

The intra-week pattern analyzer determines the intra-week pattern, which is a model for the regular intra-week and intra-day sales fluctuations of single items or categories.

The daily opening hours of the store are detected automatically from the sales transaction history.

Input Data

Relevant sales transactions in the POS Data Transfer and Audit table /POSDW/TLOGF. Only sales transactions until the end of the last complete week are considered.

Prerequisites

You have adapted the number of weeks for which transactions in table /POSDW/TLOGF are considered, to determine the intra-week pattern. Make sure that this table contains data for at least these weeks. There is a default value. You have defined the number of weeks in Customizing under Start of the navigation path SAP Customer Activity Repository Next navigation step On-Shelf Availability Next navigation step Initialize On-Shelf Availability Algorithm End of the navigation path.

Activities

SAP recommends that you execute the intra-week pattern step on a weekly basis, to serve as a foundation for the estimation model step. SAP also recommends that you execute the intra-week pattern analyzer on sales from all product locations of a given sub-department. The intra-week pattern will then be valid for all product locations of this sub-department, and must be applied to all these products in the estimation model processing step. However, the intra-week pattern may be applied on the product location level for exceptionally fast-moving product locations.

Result

The resulting output data of the intra-week pattern step is stored in the /OSA/IW_PATTERN table in the database. After this step, this table contains the sales rate during a week on several aggregation levels:

  • Per product location

  • Per sub-department of a store

  • Per store

The lowest level is valid for a product location. That means if an intra-week pattern exists on product location level, the higher aggregation levels are not considered for this product location. If an intra-week pattern for the product location does not exist, the next highest existing level is used.