Analytics (with PAI 3.1.2.0) > Available PAI Dashboards > Forecast Performance > Forecast Analysis > Forecast Analysis - Technical Specification
Forecast Analysis - Technical Specification
These are the mini-dashboards and Analytical Objects that are used to populate the Forecast Analysis dashboard
Mini-Dashboard
Analytical Object
Forecast Analysis Summary
Forecast Error Analysis
Demand Forecast Analysis
Forecast Analysis Summary
The data used to generate this mini-dashboard is based on the following:
Analytical Object
AO_SPM_ForecastAnalysis_Summary_Error
Query Object
QO_SPM_ForecastAnalysis_Summary_Error
Data Source
PAI Foundation
Cab File
SPM_PAI_Foundation.cab
Query Object Primary Table
PCS_FORECAST_DETAIL
IPCS_SKU_STREAM
Query Object Tables
IPCS_SEASONAL_CONFIG
IPCS_FORECAST_DETAIL
IPCS_FCST_SKU_STREAM_METRICS
IPCS_PROCESS_TABLE
IPCS_SLICE_INFO
IPCS_MANSYSDATE
IPCS_PART_MASTER
IPCS_PART_TYPE
IPCS_LOC_MASTER
IPCS_PREPROCESSED
IPCS_FORECAST_STREAM
IPCS_PP_SEGMENTS
IPCS_SEGMENT
IPCS_PREPROCESSED_STREAM
IPCS_SEASONAL_CONFIG
Parameters
None
Predecessor Jobs
AutoPilot
Build Type
None
Build Frequency
After the Forecasting process is run
• Location
• Part Number
• Part Type
• Region
• Forecast Stream
• Forecast Method
• Forecast Parameter
• T.S. Category
• T.S. Range
Measure
Mathematical Function
# SKU-Streams
Distinct Count
# Over
Sum of Ts over Threshold
% Over
(# Over / # SKU Streams) * 100
# Under
Sum of Ts under Threshold
% Under
(# Under / # SKU Streams) * 100
# Outliers
Sum of Outlier Count
T.S. -
Weighted T.S. OF / History Avg OF
T.S. +
Weighted T.S. UF / History Avg UF
T.S.
Weighted T.S. / History Avg
Weighted MAPE / History Avg
Weighted MAD / History Avg
COV
Average of COV
Annual Forecast
Sum of Annual Forecast
History Avg
Sum of History Average
History Avg OF
Sum of History Average OF
History Avg UF
Sum of History Average UF
Weighted T.S. UF
Sum of Ts UF
Weighted T.S. OF
Sum of Ts OF
Weighted T.S.
Sum of Ts W
Weighted MAPE
Sum of MAPE W
Weighted MAD
Sum of MAD W
Forecast Error Analysis
The data used to generate this mini-dashboard is based on the following:
Analytical Object
AO_SPM_ForecastAnalysis_Summary_Error
Query Object
QO_SPM_ForecastAnalysis_Summary_Error
Data Source
PAI Foundation
Cab File
SPM_PAI_Foundation.cab
Query Object Primary Table
PCS_FORECAST_DETAIL
IPCS_SKU_STREAM
Query Object Tables
IPCS_SEASONAL_CONFIG
IPCS_FORECAST_DETAIL
IPCS_FCST_SKU_STREAM_METRICS
IPCS_PROCESS_TABLE
IPCS_SLICE_INFO
IPCS_MANSYSDATE
IPCS_PART_MASTER
IPCS_PART_TYPE
IPCS_LOC_MASTER
IPCS_PREPROCESSED
IPCS_FORECAST_STREAM
IPCS_PP_SEGMENTS
IPCS_SEGMENT
IPCS_PREPROCESSED_STREAM
IPCS_SEASONAL_CONFIG
Parameters
None
Predecessor Jobs
AutoPilot
Build Type
None
Build Frequency
After the Forecasting process is run
• Location
• Part Number
• Part Type
• Region
• Forecast Stream
• Forecast Method
• Forecast Parameter
• T.S. Category
• T.S. Range
Measure
Mathematical Function
# SKU-Streams
Distinct Count
# Over
Sum of Ts over Threshold
% Over
(# Over / # SKU Streams) * 100
# Under
Sum of Ts under Threshold
% Under
(# Under / # SKU Streams) * 100
# Outliers
Sum of Outlier Count
T.S. -
Weighted T.S. OF / History Avg OF
T.S. +
Weighted T.S. UF / History Avg UF
T.S.
Weighted T.S. / History Avg
Weighted MAPE / History Avg
Weighted MAD / History Avg
COV
Average of COV
Annual Forecast
Sum of Annual Forecast
History Avg
Sum of History Average
History Avg OF
Sum of History Average OF
History Avg UF
Sum of History Average UF
Weighted T.S. UF
Sum of Ts UF
Weighted T.S. OF
Sum of Ts OF
Weighted T.S.
Sum of Ts W
Weighted MAPE
Sum of MAPE W
Weighted MAD
Sum of MAD W
Demand Forecast Analysis
The data used to generate this mini-dashboard is based on the following:
Analytical Object
AO_SPM_DemandForecastAnalysis
Query Object
QO_SPM_DemandForecastAnalysis
Data Source
PAI Foundation
Cab File
SPM_PAI_Foundation.cab
Query Object Primary Table
IPCS_DEMAND_HISTORY
IPCS_FORECAST_DETAILS
Query Object Tables
IPCS_FCST_DETAIL_ROLLUP
IPCS_SLICE_INFO
IPCS_MANSYSDATE
IPCS_DEMAND_HIST_ROLLUP
IPCS_PREPROCESSED
IPCS_FORECAST_STREAM
IPCS_PART_MASTER
IPCS_LOC_MASTER
IPCS_PART_TYPE
IPCS_PROCESS_TABLE
IPCS_PP_SEGMENTS IPCS_SEGMENT
IPCS_ACTIVE_NET_PREPROC
IPCS_PREPROCESSED_STREAM
IPCS_SEASONAL_CONFIG
Parameters
None
Predecessor Jobs
AutoPilot
Build Type
None
Build Frequency
After the Forecasting process is run
• Forecast Method
• Forecast Stream
• Location
• Part Number
• Part Type
• Period
• Region
Measure
Mathematical Function
Forecast
Sum of Forecast Amount
Forecast Value
Sum of Forecast Value
Demand
Sum of Total Demand
Demand Value
Sum of Demand Value
Adjustment
Sum of Adjustment
Count Adjusted SKU Stream
Sum of Adjustment Count
# SKU-Streams
Distinct Count
SKU % with Overrides
Count Adjusted SKU Stream * 100 / Count of SKU Streams
MAPE vs COV - SKU Stream
The data used to generate this mini-dashboard is based on the following:
Analytical Object
AO_PAI_MAPEvsCOV
Query Object
QO_PAI_MAPEvsCOV
Data Source
PAI Foundation
Cab File
SPM_PAI_Foundation.cab
Query Object Primary Table
IPCS_FORECAST_DETAIL
IPCS_SKU_STREAM
Query Object Tables
IPCS_SEASONAL_CONFIG
IPCS_FORECAST_DETAIL
IPCS_FCST_SKU_STREAM_METRICS
IPCS_PROCESS_TABLEIPCS_SLICE_INFO
IPCS_MANSYSDATE
IPCS_PART_MASTER
IPCS_PART_TYPE
IPCS_LOC_MASTER IPCS_PREPROCESSED
IPCS_FORECAST_STREAM IPCS_PP_SEGMENTS
IPCS_SEGMENT
IPCS_PREPROCESSED_STREAM
IPCS_SEASONAL_CONFIG
Parameters
None
Predecessor Jobs
None
Build Type
None
Build Frequency
None
• Forecast Method
• Forecast Stream
• Location
• Part Number
• Part Type
• Segment
Measure
Mathematical Function
MAPE (LT)
Average of Fm.mapelt
COV
Average of Fm.cov
Annual Forecast ($)
Sum of Annual Forecast
Was this helpful?