Excess Analysis (Technical Specification)
The data used to generate the Excess Analysis dashboard is based on the following:
|
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
|
|||||||||||||||
|
