Cleansing data

Use this procedure to clean up data before processing to ensure that you receive the most helpful recommendations.
  1. Sign in as Application Administrator or Supply Management Administrator.
  2. For Application Administrator, select Supply Management > Inventory Intelligence > Configuration.
    For Supply Management Administrator, select Inventory Intelligence > Configuration.
  3. Select the Data Cleansing tab.
  4. In the Analysis Time Window section, specify this information:
    Start
    The engine recommendation is based on an analysis during a specific window of time. The Start parameter indicates how far back the analysis window starts. We recommend 364 days so that the analysis window is a history of transactions that occurred in the previous year.
    End
    Select a few days in the past for the end of the analysis window to ensure that transactions are complete.

    For example, you schedule recommendations on the fourth of every month. We recommend that you select three days before the latest transaction. This practice is to ensure that the entire previous period is included.

  5. In the Daily Data Filtering section, specify this information:
    Omit transactions prior to last stock UOM change
    When the stocked item unit of measure changes, the transactions that occurred before that change are not compatible with values that are recorded after the change. These older transactions can almost always be omitted. Select this check box to omit them.

    Daily data pertains to transactions that have occurred during a specific day or status as of that day. Because data quality is always an issue, you can set up thresholds to find outliers. When an outlier is encountered, the transaction is excluded from analysis.

  6. In the Quantity Cutoff section, specify this information:
    Issues On-hand
    Specify a number to represent the high level threshold.
    Issues
    Specify a number to represent the high level threshold.
    Receipts On-hand
    Specify a number to represent the high level threshold.
    Receipts
    Specify a number to represent the high level threshold.

    Real-world data can contain errors such as typos. If a typo exists where the daily data value exceeds the threshold, then the transaction is omitted.

  7. In the Lead Time section, specify this information:
    Lead time length cutoff
    Lead time is the number of days between when an item is ordered and when it is received. If the lead time is too large, then a data error or an unusual situation is likely. Any value that is greater than or equal to the Lead time length cutoff is excluded.
    Minimum number of lead time values
    Lead time values refer to the lead time history for an item. For example, if an item is reordered 10 times, there are 10 values indicating the number of days that occurred before each order was received.

    When there are too few lead time values for an item, they are not a strong basis for recommendations. A minimum can be set to ensure that the item has enough of a lead time history for a useful recommendation.

    Default lead time
    If the minimum number of lead time values is not reached, you can specify a default variability value to use for recommendations calculations.
    In case of insufficient lead time history
    If the minimum number of lead time values is not reached, select the parameter from which the lead time for recommendations is drawn:
    • Use Default Lead Time: The value in the Default lead time parameter is used. This is the recommended setting.
    • Use Item Location Lead Time: The lead time that is specified in Item Location is used.