Analytics (with PAI 3.1.2.0) > Available PAI Dashboards > Performance 360 > Review Reason Summary > Review Reason Summary - Technical Specification
Review Reason Summary - Technical Specification
The data used to generate this dashboard is based on the following:
Analytical Object
AO_SPM_ReviewReasonSummary
Query Object
QO_SPM_ReviewReasonSummary
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
IPCS_PREPROCESSED
IPCS_LOC_MASTER
IPCS_PART_MASTER
IPCS_PART_TYPE
IPCS_PART_FAMILY
IPCS_LOC_TYPE
IPCS_PLANNER_CODES
IPCS_REVIEW_SUBSCRIPTION
IPCS_PLANNER_COVG
IPCS_PLANNER_COVG_MAP
IPCS_PLANNER
IPCS_PP_SEGMENTS
Parameters
Name
Description
Default
PO_SPM_PlannerIdList
The ID of the planner to be included on the dashboard, separated by commas
101
PO_SPM_ReviewTypeList
The list of Review Types 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
These AutoPilot processes need to run before building the cube:
• Generate Order Plan
• Forecasting
• 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
• Planner Code
• Review Age
• Review Reason
• Review Reason SKU
• Review Status
Measure
Mathematical Function
#
Distinct Count of DistinctRR
Magnitude
Sum of Magnitude
Review Status
Count of Isreviewed
SKU
Distinct Count of SKU
Part
Distinct Count of Part ID
Review Age
Average of Review Age, calculated as System Date – First Create Date
Was this helpful?