AO_SPM_ExcessAnalysis
View dashboard associations 
Build information
Analytical Object
AO_SPM_ExcessAnalysis
Query Object
QO_SPM_ExcessAnalysis
Data Source
PAI Foundation
Cab File
SPM_PAI_Foundation.cab
Query Object Primary Table
IPCS_EXCEPTION
Query Object Tables
IPCS_PREPROCESSED
IPCS_STOCK_AMOUNT
IPCS_EXCEPTION
IPCS_FORECASTED_DATA
IPCS_SLICE_INFO
IPCS_PART_MASTER
IPCS_LOC_MASTER
IPCS_STOCK_LEVEL
IPCS_PLANNER_CODES
IPCS_LOC_TYPE
IPCS_PART_TYPE
IPCS_PART_FAMILY
IPCS_REGION
IPCS_SKU
Parameters
None
Predecessor Jobs
These AutoPilot processes need to run before building the cube:
Generate Order Plan
Review Process
Build Type
The following build types are supported:
Full
Build Frequency
These build frequencies are supported:
Daily
Location
Location Type
Part Family
Part Number
Part Type
Planner Code
Region
Measure
Mathematical Function
Excess
Sum of Excessvalue
Stock Max
Sum of Stockmaxvalue
Annual Forecast
Sum of Annualforecast
OnHand Value
Sum of Onhandvalue
Days of Excess Supply
Average of Days of Excess Supply
* 
A value of 0 is displayed when either of the following are true:
The Forecast is 0
The forecast data is not available for the SKU
Was this helpful?