AO_PAI_DemandForecastAnalysis
View dashboard associations
Build information
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) |
|
|
