Review Reason Summary (Technical Specification)

Analytics (with PAI) > Performance 360 > Review Reason Summary > 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 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

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

Dimensions

• Location

• Location Type

• Part Family

• Part Number

• Part Type

• Planner

• Planner Code

• Review Age

• Review Reason

• Review Reason SKU

• Review Status

Measures

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?