Show TOC

 Analysis for Reporting Purposes

 

For a specified analysis period, the analysis step determines the time intervals in which the product location was probably out-of-shelf. Therefore, it analyzes the length of each sales interval between two subsequent sales of the product location, in a defined analysis period. Typically, long intervals indicate potential on-shelf availability issues.

For the period to be analyzed, the analysis step applies the estimated model, as determined in the estimation step, to the starting points of all sales transaction intervals. For each transaction interval, the estimation result used is the one that is as close as possible to before the start of the transaction interval. For all sales transactions intervals, the critical waiting time is determined. If the transaction interval is longer than the maximum tolerable waiting time, the interval is considered as an out-of-shelf-situation.

Input Data
  • Sales transactions: All sales transactions in the analysis period in table /POSDW/TLOGF

  • Estimation results: Parameter values of the estimation model that has been determined for the relevant product location, in the estimation step.

Product Locations Excluded from Analysis

The analysis step is performed only for product locations where the following condition is fulfilled:

  • In the estimation model for the product location, a quality of fit has been determined that is below the defined confidence threshold for the analysis step.

Prerequisites

You have defined the /OSA/ANA_MIN_QOF (Minimum Quality of fit (QOF) for Analysis Step) and the /OSA/ANA_THRESHOLD (Analytical Threshold) parameter for monitoring in Customizing, under Start of the navigation path SAP Customizing Implementation Guide Next navigation step SAP Customer Activity Repository Next navigation step On-Shelf Availability Next navigation step Initialize On-Shelf Availability Algorithm End of the navigation path.

  • A product location is calculated in the analysis step only if the quality of fit determined by the estimation step is equal to or above the defined minimum value for the monitoring step.

  • The confidence level threshold indicates the sensitivity of an out-of-shelf alert. Based on the confidence level threshold parameters, the critical time is determined. With this analytical threshold, you can configure the ratio between false alerts and true alerts depending on the intended purpose:

    • High confidence level value: Low false alert rate

    • Low confidence level value: Early detection of an out-of-shelf situation

Activities

The analysis step is computationally intensive. Therefore, you should run it in a non-critical time slot and only as often as necessary, for example once a week.

Result

The result of the analysis step is stored in the /OSA/MON_ANA table. After this step, this table contains the transaction intervals that are probably out-of-shelf situations. There is additional information about these intervals:

  • Lost transactions

  • Lost sales

  • Lost revenue (lost turnover)

  • The probability of being out-of-shelf of a certain product in a location, during a certain transaction interval