Analytics (with PAI 5.0.0.1) > Glossary > -A- > Analytical Object > AO_PAI_ForecastErrorAnalysis
AO_PAI_ForecastErrorAnalysis
View dashboard associations 
Forecast Analysis — Advanced
Forecast Error Analysis — Advanced
Build information
Analytical Object
AO_PAI_ForecastErrorAnalysis
Query Object
QO_PAI_ForecastErrorAnalysis
Data Source
PAI Advanced
Cab File
SPM_PAI_Advanced.cab
Query Object Primary Table
IPCS_FORECAST_ERROR
IPCS_FCST_SKU_STREAM_METRICS
IPCS_SEASONAL_CONFIG
Query Object Tables
IPCS_SEASONAL_CONFIG
IPCS_FCST_SKU_STREAM_METRICS
IPCS_FORECAST_ERROR
IPCS_PART_MASTER
IPCS_PART_TYPE
IPCS_LOC_MASTER
IPCS_ACTIVE_NET_PREPROC
IPCS_PREPROCESSED_STREAM
IPCS_PP_SEGMENTS
IPCS_SEGMENT
IPCS_PREPROCESSED
IPCS_PROCESS_TABLE
IPCS_SLICE_INFO
IPCS_MANSYSDATE
Parameters
Name
Description
Default
PO_ForecastAccuracyLTThreshold
Specify the forecast accuracy lead time threshold to filter data for Metrics for Under Forecasted SKU Streams
25
PO_ForecastMethod
Forecast Methods that should be displayed
N/A
Predecessor Jobs
None
Build Type
The following build types are supported:
• Full
• Incremental
• Consolidated
Build Frequency
The following build frequencies are supported:
• Daily
• Weekly
• Monthly
Dimensions for Forecast Error Analysis Summary mini-dashboard:
◦ Forecast Category
◦ Forecast Method
◦ Location
◦ Part Type
◦ Period
◦ Segment
Dimensions for Forecast Error Analysis Grid mini-dashboard
◦ Part
◦ Part Type
◦ Period
Dimensions for Forecast Error Analysis — Advanced dashboard
◦ Location
◦ Forecast Parameters
◦ Forecast Stream
◦ Demand Category
◦ Part Number
◦ Forecast Method
Measures for Forecast Error Analysis Summary mini-dashboard:
Measure
Mathematical Function
# SKU-Streams
Distinct Count
Weighted Accuracy (3 Period)
Sum of Accuracy 3 W
Sum of Historyavg
Accuracy (3 Period)
A mathematical calculation that contains Weighted Accuracy (3 Period) / History Avg
Weighted Accuracy (6 Period)
Sum of Accuracy 6 W
Accuracy (6 Period)
A mathematical calculation that contains Weighted Accuracy (6 Period)/History Avg
Weighted Accuracy (LT)
Sum of Accuracy (LT)
Measures for Forecast Error Analysis Grid mini-dashboard
Measure
Mathematical Function
MSE (3 Period)
A mathematical calculation that contains Weighted MSE (3 Period) / History Avg
MAD (3 Period)
A mathematical calculation that contains Weighted MAD (3 Period) / History Avg
MAPE (3 Period)
A mathematical calculation that contains Weighted MAPE (3 Period) / History Avg
MSE (6 Period)
A mathematical calculation that contains Weighted MSE (6 Period) / History Avg
MAD (6 Period)
A mathematical calculation that contains Weighted MAD (6 Period) / History Avg
MAPE (6 Period)
A mathematical calculation that contains Weighted MAPE (6 Period) / History Avg
MSE (LT)
A mathematical calculation that contains Weighted MSE (LT) / History Avg
MAD (LT)
A mathematical calculation that contains Weighted MAD (LT) / History Avg
MAPE (LT)
A mathematical calculation that contains Weighted MAPE (LT) / History Avg
Demand
Sum of History Amount
Forecast
Sum of Forecast Amount
Demand (3 Period)
Sum of History Amount 3 Months
Forecast (3 Period)
Sum of Forecast Amount 3 Months
Demand (6 Period)
Sum of History Amount 6 Months
Forecast (6 Period)
Sum of Forecast Amount 6 Months
Demand (LT)
Sum of History Amount LT
Forecast (LT)
Sum of Forecast Amount LT
Δ Demand Forecast
A mathematical calculation that contains Demand - Forecast
Δ Demand Forecast (3 Period)
A mathematical calculation that contains Demand (3 Period) * Forecast (3 Period)
Δ Demand Forecast (6 Period)
A mathematical calculation that contains Demand (6 Period) * Forecast (6 Period)
Δ Demand Forecast (LT)
A mathematical calculation that contains Demand - Forecast
Weighted Accuracy (3 Period)
Sum of Accuracy 3 W
Sum of History Average
Accuracy (3 Period)
A mathematical calculation that contains Weighted Accuracy (3 Period) / History Avg
Weighted Accuracy (6 Period)
Sum of Accuracy 6 W
Accuracy (6 Period)
A mathematical calculation that contains Weighted Accuracy (6 Period) / History Avg
Weighted Accuracy (LT)
Sum of Accuracy (LT)
Accuracy (LT)
A mathematical calculation that contains Weighted Accuracy / History Avg
Weighted T.S. UF (3 Period)
Sum of T.S. UF (3 Period)
T.S. + (3 Period)
A mathematical calculation that contains Weighted T.S. UF (3 Period) / History Avg
Weighted T.S. OF (3 Period)
Sum of T.S. OF (3 Period)
T.S. - (3 Period)
A mathematical calculation that contains Weighted T.S. OF (3 Period) / History Avg
Weighted T.S. (3 Period)
Sum of T.S. (3 Period)
T.S. (3 Period)
A mathematical calculation that contains Weighted T.S. OF (3 Period) / History Avg
Weighted T.S. UF (6 Period)
Sum of T.S. UF (6 Period)
T.S. + (6 Period)
A mathematical calculation that contains Weighted T.S. UF (6 Period) / History Avg
Weighted T.S. OF (6 Period)
Sum of T.S. OF (6 Period)
T.S. - (6 Period)
A mathematical calculation that contains Weighted T.S. OF (6 Period) / History Avg
Weighted T.S. (6 Period)
Sum of T.S. (6 Period)
T.S. (6 Period)
A mathematical calculation that contains Weighted T.S. (6 Period) / History Avg
Weighted T.S. UF (LT)
Sum of T.S. UF (LT)
T.S. + (LT)
A mathematical calculation that contains Weighted T.S. UF (LT) / History Avg
Weighted T.S. OF (LT)
Sum of T.S. OF (LT)
T.S. - (LT)
A mathematical calculation that contains Weighted T.S. OF (LT) / History Avg
# + 0.0-0.2
Sum of Ts U Lt A
# + 0.2-0.5
Sum of Ts U Lt B
# + 0.5-1.0
Sum of Ts U Lt C
# - 0.0-0.2
Sum of Ts O Lt A
# - 0.2-0.5
Sum of Ts O Lt B
# - 0.5-1.0
Sum of Ts O Lt C
# 0-50
Sum of Fa Lt A
# 50-70
Sum of Fa Lt B
# 70-100
Sum of Fa Lt C
Weighted T.S. (3 Period)
Sum of Ts 3 W
T.S. (3 Period)
A mathematical calculation that contains Weighted T.S. (3 Period) * History Average
Weighted T.S. (6 Period)
Sum of Ts6 W
T.S. (6 Period)
A mathematical calculation that contains Weighted T.S. (6 Period) * History Average
Weighted T.S. (LT)
Sum of Tslt W
T.S. (LT)
A mathematical calculation that contains Weighted T.S. (LT) * History Average
Weighted MSE (3 Period)
Sum of Mse3 W
Weighted MAD (3 Period)
Sum of Mad3 W
Weighted MAPE (3 Period)
Sum of Mape3 W
Weighted MSE (6 Period)
Sum of Mse6 W
Weighted MAD (6 Period)
Sum of Mad6 W
Weighted MAPE (6 Period)
Sum of Mape6 W
Weighted MSE (LT)
Sum of Mselt W
Weighted MAD (LT)
Sum of Madlt W
Weighted MAPE (LT)
Sum of Mapelt W
Sum of Historyavg3 UF
Sum of Historyavg3 OF
Sum of Historyavg6 UF
Sum of Historyavg6 OF
Sum of Historyavglt UF
History AvgLT OF
Sum of Historyavglt OF
Measures for Forecast Error Analysis — Advanced dashboard
Measure
Mathematical Function
# SKU-Streams
Total number of SKU-Streams
Accuraccy (LT) Over
Σ(Forecast Accuracy * History Average) / Σ(History Average)
Accuraccy (LT) Under
Σ(Forecast Accuracy * History Average) / Σ(History Average)
Bias ($)
((Total Forecast-Total Demand) / # of Slice for Forecast Error Calculation)
Bias Over
When Bias is <0
Bias Under
When Bias is >0
Bias Value ($)
(Bias* Part Cost)
Bias Value Over
(Bias * Part Cost) when Bias is <0
Bias Value Under
(Bias * Part Cost) when Bias is <0
COV
COV = History Standard Deviation / History Average
Forecast Accuracy Over
Forecast Accuracy(LT) * History Average when Bias <0
Forecast Accuracy Under
Forecast Accuracy(LT) * History Average when Bias >0
Theaveragehistorical demand for all slices used
History Avg Over
The average historical demand when Bias <0
History Avg Under
The average historical demand when Bias >0
[Σ N observations (Abs(Demand of X periods - Forecast of X periods))] / [Σ N observations ((Demand of X periods + Forecast of X periods) / 2)]
Weighted Accuracy Over
Forecast Accuracy(LT) * History Average when Forecast Accuracy >0 and Bias >0
Weighted Accuracy Under
Forecast Accuracy(LT) * History Average when Forecast Accuracy >0 and Bias <0
Was this helpful?