Forecast Analysis - Advanced - Technical Specification
These are the mini-dashboards and Analytical Objects that are used to populate the Forecasting Analysis - Advanced dashboard
Mini-Dashboard | Analytical Object |
|---|
Forecast Error Analysis Summary | |
Forecast Error Analysis Graph | |
Forecast Error Analysis Grid | |
Demand Forecast Analysis - Advanced | |
MAPE vs COV - SKU Stream | |
Forecast Error Analysis Summary
The data used to generate this mini-dashboard is based on the following:
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 |
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 | None |
Predecessor Jobs | None |
Build Type | None |
Build Frequency | None |
| 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 |
| Measures for Forecast Error Analysis Summary mini-dashboard: Measure | Mathematical Function |
|---|
# SKU-Streams | Distinct Count | Weighted Accuracy (3 Period) | Sum of Accuracy 3 W | History Avg | 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 | | A mathematical calculation that contains Weighted MAD (3 Period) / History Avg | | 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 | | A mathematical calculation that contains Weighted MAD (6 Period) / History Avg | | A mathematical calculation that contains Weighted MAPE (6 Period) / History Avg | MSE (LT) | A mathematical calculation that contains Weighted MSE (LT) / History Avg | | A mathematical calculation that contains Weighted MAD (LT) / History Avg | | 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 | History Avg | 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 | | Sum of Mad3 W | | Sum of Mape3 W | Weighted MSE (6 Period) | Sum of Mse6 W | | Sum of Mad6 W | | Sum of Mape6 W | Weighted MSE (LT) | Sum of Mselt W | | Sum of Madlt W | | Sum of Mapelt W | History Avg3 UF | Sum of Historyavg3 UF | History Avg3 OF | Sum of Historyavg3 OF | History Avg6 UF | Sum of Historyavg6 UF | History Avg6 OF | Sum of Historyavg6 OF | History AvgLT UF | Sum of Historyavglt UF | History AvgLT OF | Sum of Historyavglt OF |
|
Forecast Error Analysis Graph
The data used to generate this mini-dashboard is based on the following:
Analytical Object | AO_PAI_ForecastErrorAnalysis_Graph |
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 |
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 | None |
Predecessor Jobs | None |
Build Type | None |
Build Frequency | None |
| None |
| Measure | Mathematical Function |
|---|
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 |
|
Demand Forecast Analysis - Advanced
The data used to generate this mini-dashboard is based on the following:
Analytical Object | AO_PAI_DemandForecastAnalysis |
Query Object | QO_PAI_DemandForecastAnalysis | If you are using Demand Bins or Forecast Bins, then copy the QO_SPM_DemandForecastAnalysis_BINS query object into the QO_SPM_DemandForecastAnalysis query object. |
|
Data Source | PAI Advanced |
Cab File | SPM_PAI_Advanced.cab |
Query Object Primary Table | IPCS_FCST_DETAIL_ROLLUP IPCS_DEMAND_HIST_ROLLUP |
Query Object Tables | IPCS_FCST_DETAIL_ROLLUP IPCS_SLICE_INFO IPCS_MANSYSDATE IPCS_DEMAND_HIST_ROLLUP IPCS_PREPROCESSED 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 | Name | Description | Default |
|---|
PO_HistoricalDmdFcstSlices | The number of historical slices to consider | 12 | PO_FutureFcstSlices | The number of future slices to consider | 6 |
|
Predecessor Jobs | None |
Build Type | None |
Build Frequency | None |
| • Forecast Method • Location • Part Number • Part Type • Period • Segment |
| Measure | Mathematical Function |
|---|
Forecast | Sum of Forecast Amount | Forecast Value | Sum of Forecast Value | Demand | Sum of History Amount | Demand Value | Sum of Demand Value | Count Adjusted SKU Stream | Sum of Adjustment Count | % SKU-Streams with Overrides | A mathematical calculation that contains (Count of Adjusted SKU Stream * 100) / Count of SKU-Streams | Count of SKU-Streams | Distinct Count | Adjustment | Sum of Adjustment | Adjustment% | A mathematical calculation that contains Adjustment * 100 / Forecast | If the Forecast value is 0 (zero), then the Adjustment value is 0 (zero) |
|
|
Forecast Error Analysis Grid
The data used to generate this mini-dashboard is based on the following:
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 |
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 | None |
Predecessor Jobs | None |
Build Type | None |
Build Frequency | None |
| 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 |
| Measures for Forecast Error Analysis Summary mini-dashboard: Measure | Mathematical Function |
|---|
# SKU-Streams | Distinct Count | Weighted Accuracy (3 Period) | Sum of Accuracy 3 W | History Avg | 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 | | A mathematical calculation that contains Weighted MAD (3 Period) / History Avg | | 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 | | A mathematical calculation that contains Weighted MAD (6 Period) / History Avg | | A mathematical calculation that contains Weighted MAPE (6 Period) / History Avg | MSE (LT) | A mathematical calculation that contains Weighted MSE (LT) / History Avg | | A mathematical calculation that contains Weighted MAD (LT) / History Avg | | 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 | History Avg | 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 | | Sum of Mad3 W | | Sum of Mape3 W | Weighted MSE (6 Period) | Sum of Mse6 W | | Sum of Mad6 W | | Sum of Mape6 W | Weighted MSE (LT) | Sum of Mselt W | | Sum of Madlt W | | Sum of Mapelt W | History Avg3 UF | Sum of Historyavg3 UF | History Avg3 OF | Sum of Historyavg3 OF | History Avg6 UF | Sum of Historyavg6 UF | History Avg6 OF | Sum of Historyavg6 OF | History AvgLT UF | Sum of Historyavglt UF | History AvgLT OF | Sum of Historyavglt OF |
|
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 Advanced |
Cab File | SPM_PAI_Advanced.cab |
Query Object Primary Table | IPCS_FORECAST_DETAIL IPCS_FCST_SKU_STREAM_METRICS |
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 |
Parameters | None |
Predecessor Jobs | None |
Build Type | None |
Build Frequency | None |
| • Forecast Method • Forecast Stream • Location • Part Number • Part Type • Segment |
| Measure | Mathematical Function |
|---|
| Average of Fm.mapelt | COV | Average of Fm.cov | Annual Forecast ($) | Sum of Annual Forecast |
|
