Analytics (with PAI 5.0.0.1) > Available PAI Dashboards > Performance 360 > Planner Workload > Planner Workload (Technical Specification)
Planner Workload (Technical Specification)
These are the mini-dashboards and Analytical Objects that are used to populate the Planner Workload dashboard
Mini-Dashboard
Analytical Object
Planner Daily Workload
Planner Performance
Order Summary
Planner Daily Workload
The data used to generate this mini-dashboard is based on the following:
Analytical Object
AO_PAI_PlannerWorkload_Daily
Query Object
QO_PAI_PlannerWorkload_Daily
Data Source
PAI Advanced
Cab File
SPM_PAI_Advanced.cab
Query Object Primary Table
IPCS_REVIEW_BOARD
Query Object Tables
IPCS_REVIEW_REASONS
IPCS_REVIEW_BOARD
IPCS_LOC_MASTER
IPCS_PART_MASTER
IPCS_REVIEW_SUBSCRIPTION
IPCS_PLANNER
IPCS_PLANNER_COVG
IPCS_PLANNER_COVG_MAP
IPCS_PP_SEGMENTS
Parameters
Name
Description
Default
PO_PAI_ReviewTypeList
The list of Review Reasons that can be included on the dashboard, separated by commas
1,86,138,139,331,334,329,19,18,332,323,324,325,326
Predecessor Jobs
None
Build Type
The following build types are supported:
• Full
Build Frequency
These build frequencies are supported:
• Daily
• Weekly
• Monthly
• Date
• Planner
• Review Reason
• Review Status
Measure
Mathematical Function
Daily Total
Sum of Daily Total
Total Daily Reviewed
Sum of Total Daily Reviewed
Total Daily In Queue
Sum of Total Daily In Queue
DistinctRR
Distinct Count of Review REasons
DistinctDates
Distinct Count of Archival Date
Daily Avg
Daily Total / Distinct RR
Daily Reviewed Avg
Total Daily Reviewed / Distinct RR
Daily In Queue Avg
Total Daily In Queue / Distinct RR
Total SKU
Distinct Count of SKUs
Total Parts
Distinct Count of Parts
SKU Daily Avg
Total SKU / Distinct Dates * 30
Parts Daily Avg
Total Parts / Distinct Dates * 30
Planner Performance
The data used to generate this mini-dashboard is based on the following:
Analytical Object
AO_PAI_PlannerPerformance
Query Object
QO_PAI_PlannerPerformance
Data Source
PAI Advanced
Cab File
SPM_PAI_Advanced.cab
Query Object Primary Table
IPCS_REVIEW_BOARD
Query Object Tables
IPCS_REVIEW_BOARD
IPCS_REVIEW_REASONS
IPCS_LOC_MASTER
IPCS_PART_MASTER
IPCS_REVIEW_SUBSCRIPTION
IPCS_PLANNER_COVG
IPCS_PLANNER_COVG_MAP
IPCS_PLANNER
IPCS_PP_SEGMENTS
Parameters
Name
Description
Default
PO_PAI_ReviewTypeList
The list of Review Reasons that can be included on the dashboard, separated by commas
1,86,138,139,331,334,329,19,18,332,323,324,325,326
PO_PAI_PlannerIdList
The ID of the planner to be included on the dashboard, separated by commas
101
Predecessor Jobs
None
Build Type
The following build types are supported:
• Full
Build Frequency
These build frequencies are supported:
• Daily
• Weekly
• Monthly
• Age Category
• Date
• Planner
• Review Reason
Measure
Mathematical Function
#
Distinct Count of Review Reasons
Review Age
Average of Review Age
Order Summary
The data used to generate this mini-dashboard is based on the following:
Analytical Object
AO_PAI_PlannerWorkloadOrderSummary
Query Object
QO_PAI_PlannerWorkloadOrderSummary
Data Source
PAI Advanced
Cab File
SPM_PAI_Advanced.cab
Query Object Primary Table
IPCS_ORDER_PLAN
Query Object Tables
IPCS_ORDER_PLAN
IPCS_PP_SEGMENTS
IPCS_PLANNER_COVG
IPCS_PLANNER_COVG_MAP
IPCS_PLANNER
Parameters
None
Predecessor Jobs
None
Build Type
The following build types are supported:
• Full
Build Frequency
These build frequencies are supported:
• Daily
• Weekly
• Monthly
• Planner
• Order Type
• Date
• Order Status
Measure
Mathematical Function
Total
Distinct Count of orders
Daily Average
Sum of Daily Average
Was this helpful?