AO_SPM_VendorPerformanceManagement
View dashboard associations
Build information
Analytical Object | AO_SPM_VendorPerformanceManagement |
Query Object | QO_SPM_VendorPerformanceManagement |
Data Source | PAI Foundation |
Cab File | SPM_PAI_Foundation.cab |
Query Object Primary Table | IPCS_ORDER_PLAN_HISTORY |
Query Object Tables | IPCS_ORDER_PLAN_HISTORY VENDORSLIST IPCS_PART_MASTER IPCS_LOC_MASTER IPCS_VENDOR_LOC IPCS_VENDORS IPCS_STOCK_LEVEL IPCS_FORECASTED_DATA |
Parameters | Name | Description | Default |
|---|
PO_SPM_VendorMinOrders | The minimum number of orders to consider | 10 |
|
Predecessor Jobs | Build the cube after every Order Plan History archival process |
Build Type | The following build types are supported: • Full |
Build Frequency | These build frequencies are supported: • Daily |
| • Location • Part Number • Vendor • Vendor Location • Delivery Status • Delivery by Days |
| Measure | Mathematical Function |
|---|
Actual Std Deviation | Maximum of Actual Std Deviation | Actual Average | Maximum of Actual Average | Actual COV | Expression containing [Actual Std Deviation]/[Actual Average] | Actual Lead Time | Average of Procurement Length | Delay | A mathematical calculation that contains Actual Lead Time – Servigistics Lead Time | Delay Impact ($) | A mathematical calculation that contains Delay * One Day Demand Value | A value of $0.00 is displayed when either of the following are true: • The Delay is 0 • The forecast data is not available for the SKU |
| Delivery Status | Count of Delivery Status | The sort order of Vendors is displayed in descending order, based on the first legend show in the widget. For example, sorted by Early, or Late, or On Time delivery status, whichever is displayed first. |
| Number of Orders | Count of Procurement Length | One Day Demand Value | Sum of One Day Demand Value | Servigistics COV | Maximum of Planncov | Servigistics Lead Time | Average of SL Procurement Length | Servigistics Std Deviation | Maximum of Plannedsd | Total Spend ($) | Sum of Order Price | Δ Std Deviation | A mathematical calculation that contains Actual Std Deviation-Servigistics Std Deviation | Δ COV | A mathematical calculation that contains Actual COV-Servigistics COV |
|
