Analytics (with PAI 3.1.2.0) > Available PAI Dashboards > Performance 360 > Pricing Review Reason Summary > Pricing Review Reason Summary - Technical Specification
Pricing Review Reason Summary - Technical Specification
The data used to generate this dashboard is based on the following:
Analytical Object
AO_SPP_PricingReviewReasons
Query Object
QO_SPP_PricingReviewReasons
Data Source
PAI Foundation
Cab File
SPP_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_SPP_PlannerIdList
The ID of the planner to be included on the dashboard, separated by commas
102
PO_SPP_ReviewTypeList
The list of Review Types that can be included on the dashboard, separated by commas
90, 113, 114
Predecessor Jobs
These AutoPilot processes need to run before building the cube:
• 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?