Overview of Archival for Calculating MAPE Statistics

A Supply Chain Planning administrator with the Manage Rolling Archives security privilege can create archives for the calculation of the MAPE statistics at a week or month level.

These archives are used to calculate predefined measures for demand plans and sales and operations plans that use archived data. The administrator runs the Build Plan Archive scheduled process from the Tools work area.

Shipments or bookings measures are required in the archive for MAPE statistics calculations, based on the measure used to create the forecast. If your plan forecasts shipments data, then only the shipments forecast measures are needed. If your plan forecasts bookings data, then only the bookings measures are needed. The following shipments or bookings measures are required:

  • Final Shipments Forecast

  • Final Shipments Forecast 3 Months Ago

  • Final Shipments Forecast 3 Months Ago Latest Archive

  • Final Bookings Forecast

  • Final Bookings Forecast 3 Months Ago

  • Final Bookings Forecast 3 Months Ago Latest Archive

To use the archives in a waterfall or trend analysis, select the Use MAPE calculations check box in the Selector Tool Comparison Options tab.

MAPE archives created on a rolling basis can be referenced in a user-defined measure expression that uses the Archive function. The archive type is a parameter of this function. The valid values for archive type are "Rolling" and "Adhoc."