Analytics (with PAI) > 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
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
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:
• 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
Reviewed
Total Daily Reviewed / Distinct RR
In Queue
Total Daily In Queue / Distinct RR
Total SKU
Distinct Count of SKUs
Total Parts
Distinct Count of Parts
SKU
Total SKU / Distinct Dates * 30
Parts
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:
• Monthly
• Age Category
• Date
• Planner
• Review Reason
Measure
Mathematical Function
#
Distinct Count of Review Reasons
Was this helpful?