Analytics (with PAI 5.0.0.1) > Available PAI Dashboards > Performance 360 > Performance 360 Advanced > Performance 360 Advanced (Technical Specification)
Performance 360 Advanced (Technical Specification)
These are the widgets and their associated Analytical Objects that are used to populate the Performance 360 dashboard:
Widget
Analytical Object
Fill Rate Trend
Demand Miss Analysis
Inventory Trend
These are the widgets and their associated Query Objects that are used to populate the Performance 360 dashboard:
Widget
Analytical Object
Top Review Reasons
Forecast Categories by Tracking Signal
Spend History and Projection
Demand Forecast Analysis
Vendor Delivery Status
Excess by Location
Fill Rate Trend
The system level trend comparison of Planned unit fill rate vs Actual unit fill rate.
Analytical Object
AO_PAI_FillRateDaily_System
Query Object
QO_PAI_FillRateDaily_System
Data Source
PAI Advanced
Cab File
SPM_PAI_Advanced.cab
Query Object Primary Table
IPCS_FILLRATE_DAILY (Populated using IPCS_DEMAND_DETAIL, IPCS_Stock_Amount and IPCS_Order_Plan)
IPCS_SERVICE_GROUP_INFO (Populated using service group information of latest promoted scenarios)
Query Object Tables
IPCS_FILLRATE_DAILY
IPCS_STOCK_LEVEL
IPCS_SERVICE_GROUP_INFO
IPCS_ACTIVE_NET_PREPROC
IPCS_MEO_CURRENT_PROD_SKU
Parameters
Name
Description
Default
PO_PAI_FillRateAnalysisHorizonMonths
The number of months to build the analytical object
12
* 
This parameter addresses performance issues during the building of the cube when there are large amounts of data being fetched by the query. Fetching more than 1 million records can result in performance issues during the cube build.
Reducing the horizon months can resolve potential performance issues.
Predecessor Jobs
Archival
Build Type
The following build types are supported:
• Full
* 
If past Demand Detail data is updated, then a Full build is recommended to update the cube data that was already built.
Build Frequency
These build frequencies are supported:
• Daily
• Stockable
• Location
• Part Number
• Period
• TMR
Measure
Mathematical Function
Unit fillrate with weight
Sum of Unitfillratewithweight
Quantity Filled
Sum of Quantityfilled
Actual Unit Fill Rate
Unit Fillrate with Weight * Total
Planned fillrate with Weight
Sum of Plannedfillratewithweight
Planned Unit Fill Rate
Planned Fillrate with Weight * Total
Delta Fill Rate
Actual Unit Fillrate - Planned Unit Fillrate
Missed
Total - Quantity Filled
Line fillrate with weight
Sum of Linefillratewithweight
Line Requested
Sum of Linesrequested
Lines Filled
Sum of Linefilled
Actual Line Fill Rate
Line Fillrate with Weight * Total Line
Planned line fillrate with weight
Sum of Plannedlinefillratewithweight
Planned Line Fill Rate
Planned Line Fillrate with Weight * Total Line
Delta Line Fill Rate
Actual Line Fillrate - Planned Line Fillrate
Line Missed
Total Line - Lines Filled
Total
Sum of Quantityrequested
Total Line
Sum of Linesrequested
Unplanned Missed
Delta Unit Fill Rate * Total
Unplanned Line Missed
Delta Line Fill Rate * Total Line
Demand Miss Analysis
Identifies Demand Miss trend with root cause category.
Analytical Object
AO_PAI_DemandMissFillRate
Query Object
QO_PAI_DemandMissFillRate
Data Source
PAI Advanced
Cab File
SPM_PAI_Advanced.cab
Query Object Primary Table
IPCS_FILLRATE_DAILY (Populated using IPCS_DEMAND_DETAIL, IPCS_Stock_Amount and IPCS_Order_Plan)
IPCS_STOCK_AMOUNT
IPCS_STOCK_LEVEL
IPCS_FORECASTED_DATA
IPCS_PLANNER_CODES
IPCS_ORDER_PLAN_SCALARS
IPCS_DEMAND_HISTORY
IPCSV_MEO_CURRENT_PROD_SKU
ipcs_demand_miss_onasl_with_onorder
IPCS_DEMAND_MISS_ONASL_WITH_ONORDER_VENDORDELAY
Query Object Tables
IPCS_FILLRATE_DAILY
IPCS_STOCK_AMOUNT
IPCS_ACTIVE_NET_PREPROC
IPCS_PART_MASTER
IPCS_LOC_MASTER
IPCS_STOCK_LEVEL
IPCS_FORECASTED_DATA
IPCS_PLANNER_CODES
IPCS_ORDER_PLAN_SCALARS
IPCS_DEMAND_HISTORY IPCSV_MEO_CURRENT_PROD_SKU
IPCS_NS_LOC_TREE
ipcs_preprocessed
ipcs_demand_miss_onasl_with_onorder
IPCS_DEMAND_MISS_ONASL_WITH_ONORDER_VENDORDELAY
Parameters
Name
Description
Default
PO_PAI_DemandMissHorizonMonths
The number of months to build the analytical object
12
* 
This parameter addresses performance issues during the building of the cube when there are large amounts of data being fetched by the query. Fetching more than 1 million records can result in performance issues during the cube build.
Reducing the horizon months can resolve potential performance issues.
PO_PAI_SKU_Seperator
The separator used to combine Part Number with Location and display as an SKU
__ (double underscore)
Predecessor Jobs
Archival
Build Type
The following build types are supported:
• Full
* 
If past Demand Detail data is updated, then a Full build is recommended to update the cube data that was previously built.
Build Frequency
These build frequencies are supported:
• Daily
• Part Number
• Location
• Planner Code
• SKU
• Category
• Period
Measure
Mathematical Function
Total Demand Miss
Quantityrequested - Quantityfilled
On ASL with OnOrder
Sum of Aslwithonorder
On ASL without OnOrder
Sum of Aslwithoutonorder
Forced non-stock
Sum of Forcednonstock
System Chose Not to Stock and Forecast exists
Sum of Nottostockforecastexist
System Chose Not to Stock and No Forecast exists
Sum of Nottostocknoforecastexist
No Supply Source
Sum of Nosupplysource
First Time Demand
Sum of Firsttimedemand
NotCategorized
Sum of Otherscategory
Quantityrequested
Sum of Quantityrequested
Quantityfilled
Sum of Quantityfilled
Inventory Trend
Shows average inventory trend with status such as critically short, in range and excess values.
Analytical Object
AO_PAI_Performance360_InventoryTrend
Query Object
QO_PAI_Performance360_InventoryTrend
Data Source
PAI Advanced
Cab File
SPM_PAI_Advanced.cab
Query Object Primary Table
IPCS_STOCK_AMOUNT
IPCS_STOCK_LEVEL
Query Object Tables
IPCS_PREPROCESSED
IPCS_PART_MASTER
IPCS_LOC_MASTER
IPCS_PART_TYPE
IPCS_PART_FAMILY
IPCS_LOC_TYPE
IPCS_SKU
IPCS_STOCK_AMOUNT
IPCS_STOCK_LEVEL
Parameters
None
Predecessor Jobs
Archival
Build Type
The following build types are supported:
• Full
Build Frequency
These build frequencies are supported:
• Daily
• Weekly
• Monthly
• Period
• Part Number
• Location Type
• Part Family
• Part Type
• Location
Measure
Mathematical Function
Inventory Value sum
Sum of inventoryvalue
Critically Short Sum
Sum of criticallyshort
Backorder Sum
Sum of Backorder
In Range Sum
Sum of Inrange
In Excess Sum
Sum of Inexcess
No of Months
Distinct count
Inventory
Inventory Value Sum / No of Months
Critically Short
Critically Short Sum / No of Months
In Range
In Range Sum / No of Months
In Excess
In Excess Sum / No of Months
Backorder
Backorder Sum / No of Months
Top Review Reasons
The data used to generate this widget is based on the following:
Article
Description
Analytical Object
N/A
Query Object
QO_SPM_Performance360_TopReviewReasons
Data Source
PAI Foundation
Cab File
SPM_PAI_Foundation.cab
Query Object Primary Table
IPCS_REVIEW_BOARD
Query Object Tables
IPCS_REVIEW_BOARD
IPCS_REVIEW_REASONS
IPCS_REVIEW_CATEGORY
PCS_REVIEW_SUBSCRIPTION
IPCS_LOC_MASTER
IPCS_PART_MASTER
Forecast Categories by Tracking Signal
The data used to generate this widget is based on the following:
Article
Description
Analytical Object
N/A
Query Object
QO_SPM_Performance360_ForecastCategory
Data Source
PAI Foundation
Cab File
SPM_PAI_Foundation.cab
Query Object Primary Table
IPCS_SKU_STREAM
IPCS_FORECAST_DETAIL
Query Object Tables
IPCS_SKU_STREAM
IPCS_PART_MASTER
IPCS_LOC_MASTER
IPCS_FORECAST_STREAM
IPCS_PREPROCESSED
IPCS_ACTIVE_NET_PREPROC
IPCS_PROCESS_CONFIG
IPCS_STREAM_CONFIG_DETAIL
IPCS_FORECAST_DETAIL IPCS_SLICE_INFO
Spend History and Projection
The data used to generate this widget is based on the following:
Article
Description
Analytical Object
N/A
Query Object
QO_SPM_Performance360_SpendHistoryAndProjection
Data Source
PAI Foundation
Cab File
SPM_PAI_Foundation.cab
Query Object Primary Table
IPCS_ORDER_PLAN
IPCS_ORDER_PLAN_HISTORY
Query Object Tables
IPCS_ORDER_PLAN_PARTLOC_KITS
IPCS_ORDER_PLAN
IPCS_ORDER_PLAN_HISTORY
IPCS_PART_MASTER
IPCS_SKU
Parameters
Name
Description
Default
PO_Performance360_DateType
Enables the Date Type display to be configured for the Spend History and Projection widget
Options are:
• Ordered
• Shipped
• Received
• Available
Available
Demand Forecast Analysis
The data used to generate this widget is based on the following:
Article
Description
Analytical Object
N/A
Query Object
QO_SPM_Performance360_DemandForecastCompare
Data Source
PAI Foundation
Cab File
SPM_PAI_Foundation.cab
Query Object Primary Table
IPCS_FORECAST_DETAIL
IPCS_DEMAND_HISTORY
Query Object Tables
IPCS_FORECAST_DETAIL
IPCS_SLICE_INFO
IPCS_PARTS_RELATIONSHIP
IPCS_LOC_MASTER
IPCS_PREPROCESSED
IPCS_ACTIVE_NET_PREPROC
IPCS_PROCESS_CONFIG
IPCS_STREAM_CONFIG_DETAIL
IPCS_DEMAND_STREAM
IPCS_FORECAST_STREAM
IPCS_DEMAND_HISTORY
Vendor Delivery Status
The data used to generate this widget is based on the following:
Article
Description
Analytical Object
N/A
Query Object
QO_SPM_Performance360_VendorDeliveryStatus
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
IPCS_PART_MASTER
IPCS_LOC_MASTER
IPCS_VENDOR_LOC
IPCS_VENDORS
IPCS_STOCK_LEVEL
Excess by Location
The data used to generate this widget is based on the following:
Article
Description
Analytical Object
N/A
Query Object
QO_SPM_Performance360_ExcessByLocation
Data Source
PAI Foundation
Cab File
SPM_PAI_Foundation.cab
Query Object Primary Table
IPCS_EXCEPTION
Query Object Tables
IPCS_EXCEPTION
IPCS_PREPROCESSED
IPCS_PART_MASTER
IPCS_LOC_MASTER
IPCS_SKU
Was this helpful?