How to calculate MAPE on Final Forecast (Doc ID 1304976.1)

Goal

Can we calculate MAPE on Final Forecast? Customer needs MAPE on "Base Line Forecast" and also on "Final Forecast" . The MAPE provided out of the box is calculated on Baseline Forecast only. This tells us the accuracy of the forecast engine, but we would like to calculate MAPE on the Final Forecast as well (which includes adjustments to the Baseline Forecast). We need to understand both the accuracy of the forecast engine's forecast, and the accuracy of our Final Forecast, since the Final Forecast is what is passed to Planning for purchasing requirements. How can we configure the system to support two different MAPE calculations?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.