Analytics (with PAI) > Performance 360 > Review Reason Trend > Review Reason Trend (Technical Specification)
Review Reason Trend (Technical Specification)
These are the mini-dashboards and Analytical Objects that are used to populate the Forecast Analysis dashboard
Mini-Dashboard
Analytical Object
Forecasting
Supply Planning
Recommended Orders
Forecasting
The data used to generate this mini-dashboard is based on the following:
These are the Review Reasons used:
• Actual vs Forecast outside of calculated Demand Standard Deviation 1(1)
• Outlier Adjustment applied (86)
• Tracking Signal - Actuals Greater than Forecast (138)
• Tracking Signal - Forecast Greater than Actuals (139)
Analytical Object
AO_PAI_ReviewReasonTrend_Forecasting
Query Object
QO_PAI_ReviewReasonTrendForecast
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_PLANNER_CODES
Parameters
Name
Description
Default
PO_PAI_ReviewReasonTrendMonths
The number of months to build the analytical object
12
Predecessor Jobs
Archival
Build Type
The following build types are supported:
• Full
Build Frequency
These build frequencies are supported:
• Daily
• Weekly
• Monthly
• Location
• Part Number
• Period
• Planner Code
• Review Reason
Measure
Mathematical Function
Daily Average
Sum of Daily Average
Daily Avg
Sum of Total Daily Average
Supply Planning
The data used to generate this mini-dashboard is based on the following:
These are the Review Reasons used:
• Critically Short: Zero On Hand with Backorder (331)
• Critically Short Today (334)
• Critically Short (18)
• In Excess (19)
• Excess with host orders within Lead Time (329)
Analytical Object
AO_PAI_ReviewReasonTrend_SupplyPlanning
Query Object
QO_PAI_ReviewReason_SupplyPlanning
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_PLANNER_CODES
Parameters
Name
Description
Default
PO_PAI_ReviewReasonTrendMonths
The number of months to build the analytical object
12
Predecessor Jobs
Archival
Build Type
The following build types are supported:
• Full
Build Frequency
These build frequencies are supported:
• Daily
• Weekly
• Monthly
• Location
• Part Number
• Period
• Planner Code
• Review Reason
Measure
Mathematical Function
Daily Average
Sum of Daily Average
Daily Avg
Sum of Total Daily Average
Recommended Orders
The data used to generate this mini-dashboard is based on the following:
These are the Review Reasons that are used:
• New Recommended Excess Recall Orders (332)
• New Recommended Repair Orders (323)
• New Recommended Replenishment Orders (324)
• New Recommended Balancing Orders (325)
• New Recommended Procurement Orders (326)
Analytical Object
AO_PAI_ReviewReasonTrend_ToDays
Query Object
QO_PAI_ReviewReasonTrendToDays
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_PLANNER_CODES
Parameters
Name
Description
Default
PO_PAI_ReviewReasonTrendMonths
The number of months to build the analytical object
12
Predecessor Jobs
Archival
Build Type
The following build types are supported:
• Full
Build Frequency
These build frequencies are supported:
• Daily
• Weekly
• Monthly
• Location
• Part Number
• Period
• Planner Code
• Review Reason
Measure
Mathematical Function
Daily Average
Sum of Daily Average
Daily Avg
Sum of Total Daily Average
Was this helpful?