Performance 360 Advanced - Technical Specification

Analytics (with PAI 3.1.2.0) > Available PAI Dashboards > Performance 360 > Performance 360 Advanced > Performance 360 Advanced - Technical Specification

These are the widgets and their associated Analytical Objects that are used to populate the Performance 360 dashboard:

Widget	Analytical Object
Fill Rate Trend	AO_PAI_FillRateDaily_System
Demand Miss Analysis	AO_PAI_DemandMissFillRate
Inventory Trend	AO_PAI_Performance360_InventoryTrend

These are the widgets and their associated Query Objects that are used to populate the Performance 360 dashboard:

Widget	Analytical Object
Top Review Reasons	QO_SPM_Performance360_TopReviewReasons
Forecast Categories by Tracking Signal	QO_SPM_Performance360_ForecastCategory
Spend History and Projection	QO_SPM_Performance360_SpendHistoryAndProjection
Demand Forecast Analysis	QO_SPM_Performance360_DemandForecastCompare
Vendor Delivery Status	QO_SPM_Performance360_VendorDeliveryStatus
Excess by Location	QO_SPM_Performance360_ExcessByLocation

Fill Rate Trend

The system level trend comparison of Planned unit fill rate vs Actual unit fill rate.

Analytical Object

AO_PAI_FillRateDaily_System

Query Object

QO_PAI_FillRateDaily_System

Data Source

PAI Advanced

Cab File

SPM_PAI_Advanced.cab

Query Object Primary Table

IPCS_FILLRATE_DAILY (Populated using IPCS_Demand_Detail, IPCS_Stock_Amount and IPCS_Order_Plan)

IPCS_SERVICE_GROUP_INFO (Populated using service group information of latest promoted scenarios)

Query Object Tables

IPCS_FILLRATE_DAILY

IPCS_STOCK_LEVEL

IPCS_SERVICE_GROUP_INFO

IPCS_ACTIVE_NET_PREPROC

IPCS_MEO_CURRENT_PROD_SKU

Parameters

Name

Description

Default

PO_PAI_FillRateAnalysisHorizonMonths

The number of months to build the analytical object

This parameter addresses performance issues during the building of the cube when there are large amounts of data being fetched by the query. Fetching more than 1 million records can result in performance issues during the cube build.

Reducing the horizon months can resolve potential performance issues.

Predecessor Jobs

Archival

Build Type

The following build types are supported:

• Full

If past Demand Detail data is updated, then a Full build is recommended to update the cube data that was already built.

Build Frequency

These build frequencies are supported:

• Daily

Dimensions

• IO Stockable

• Location

• Part Number

• Period

• TMR

Measures

Measure	Mathematical Function
Unit fillrate with weight	Sum of Unitfillratewithweight
Quantity Requested	Sum of Quantityrequested
Quantity Filled	Sum of Quantityfilled
Actual Unit Fill Rate	Unit fillrate with Weight / Quantity Requested
Planned fillrate with Weight	Sum of Plannedfillratewithweight
Planned Unit Fill Rate	Planned fillrate with Weight / Quantity Requested
Delta Fill Rate	Planned Unit Fill Rate - Actual Unit Fill Rate
Demand Missed	Quantity Requested - Quantity Filled
Line fillrate with weight	Sum of Linefillratewithweight
Line Requested	Sum of Linesrequested
Lines Filled	Sum of Linefilled
Actual Line Fill Rate	Line fillrate with Weight / Lines Requested
Planned line fillrate with weight	Sum of Plannedlinefillratewithweight
Planned Line Fill Rate	Planned line fillrate with Weight / Lines Requested
Delta Line Fill Rate	Planned Line Fill Rate - Actual Line Fill Rate
Line Missed	Lines Requested - Lines Filled

Demand Miss Analysis

Identifies Demand Miss trend with root cause category.

Analytical Object

AO_PAI_DemandMissFillRate

Query Object

QO_PAI_DemandMissFillRate

Data Source

PAI Advanced

Cab File

SPM_PAI_Advanced.cab

Query Object Primary Table

IPCS_FILLRATE_DAILY (Populated using IPCS_Demand_Detail, IPCS_Stock_Amount and IPCS_Order_Plan)

IPCS_STOCK_AMOUNT

IPCS_STOCK_LEVEL

IPCS_FORECASTED_DATA

IPCS_PLANNER_CODES

IPCS_ORDER_PLAN_SCALARS

IPCS_DEMAND_HISTORY

IPCSV_MEO_CURRENT_PROD_SKU

Query Object Tables

IPCS_FILLRATE_DAILY

IPCS_STOCK_AMOUNT

IPCS_ACTIVE_NET_PREPROC

IPCS_PART_MASTER

IPCS_LOC_MASTER

IPCS_STOCK_LEVEL

IPCS_FORECASTED_DATA

IPCS_PLANNER_CODES

IPCS_ORDER_PLAN_SCALARS

IPCS_DEMAND_HISTORY IPCSV_MEO_CURRENT_PROD_SKU

Parameters

Name

Description

Default

PO_PAI_DemandMissHorizonMonths

The number of months to build the analytical object

Reducing the horizon months can resolve potential performance issues.

PO_PAI_SKU_Seperator

The separator used to combine Part Number with Location and display as an SKU

__ (double underscore)

Predecessor Jobs

Archival

Build Type

The following build types are supported:

• Full

If past Demand Detail data is updated, then a Full build is recommended to update the cube data that was previously built.

Build Frequency

These build frequencies are supported:

• Daily

Dimensions

• Part Number

• Location

• Planner Code

• SKU

• Category

• Period

Measures

Measure	Mathematical Function
Total Demand Miss	Quantityrequested - Quantityfilled
On ASL with OnOrder	Sum of Aslwithonorder
On ASL without OnOrder	Sum of Aslwithoutonorder
Forced non-stock	Sum of Forcednonstock
System Chose Not to Stock and Forecast exists	Sum of Nottostockforecastexist
System Chose Not to Stock and No Forecast exists	Sum of Nottostocknoforecastexist
No Supply Source	Sum of Nosupplysource
First Time Demand	Sum of Firsttimedemand
NotCategorized	Sum of Otherscategory
Quantityrequested	Sum of Quantityrequested
Quantityfilled	Sum of Quantityfilled

Inventory Trend

Shows average inventory trend with status such as critically short, in range and excess values.

Analytical Object

AO_PAI_Performance360_InventoryTrend

Query Object

QO_PAI_Performance360_InventoryTrend

Data Source

PAI Advanced

Cab File

SPM_PAI_Advanced.cab

Query Object Primary Table

IPCS_STOCK_AMOUNT

IPCS_STOCK_LEVEL

Query Object Tables

IPCS_PREPROCESSED

IPCS_PART_MASTER

IPCS_LOC_MASTER

IPCS_PART_TYPE

IPCS_PART_FAMILY

IPCS_LOC_TYPE

IPCS_STOCK_AMOUNT

IPCS_STOCK_LEVEL

Parameters

Name	Description	Default
PO_PAI_InventoryTrendHorizonMonths	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

Dimensions

• Period

• Part Number

• Location Type

• Part Family

• Part Type

• Location

Measures

Measure	Mathematical Function
Inventory Value sum	Sum of inventoryvalue
Critically Short Sum	Sum of criticallyshort
Backorder Sum	Sum of Backorder
In Range Sum	Sum of Inrange
In Excess Sum	Sum of Inexcess
No of Months	Distinct count
Inventory	Inventory Value Sum / No of Months
Critically Short	Critically Short Sum / No of Months
In Range	In Range Sum / No of Months
In Excess	In Excess Sum / No of Months
Backorder	Backorder Sum / No of Months

Top Review Reasons

The data used to generate this widget is based on the following:

Article	Description
Analytical Object	N/A
Query Object	QO_SPM_Performance360_TopReviewReasons
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 PCS_REVIEW_SUBSCRIPTION IPCS_LOC_MASTER IPCS_PART_MASTER

Forecast Categories by Tracking Signal

The data used to generate this widget is based on the following:

Article	Description
Analytical Object	N/A
Query Object	QO_SPM_Performance360_ForecastCategory
Data Source	PAI Foundation
Cab File	SPM_PAI_Foundation.cab
Query Object Primary Table	IPCS_SKU_STREAM IPCS_FORECAST_DETAIL
Query Object Tables	IPCS_SKU_STREAM IPCS_PART_MASTER IPCS_LOC_MASTER IPCS_FORECAST_STREAM IPCS_PREPROCESSED IPCS_ACTIVE_NET_PREPROC IPCS_PROCESS_CONFIG IPCS_STREAM_CONFIG_DETAIL IPCS_FORECAST_DETAIL IPCS_SLICE_INFO

Spend History and Projection

The data used to generate this widget is based on the following:

Article

Description

Analytical Object

N/A

Query Object

QO_SPM_Performance360_SpendHistoryAndProjection

Data Source

PAI Foundation

Cab File

SPM_PAI_Foundation.cab

Query Object Primary Table

IPCS_ORDER_PLAN

IPCS_ORDER_PLAN_HISTORY

Query Object Tables

IPCS_ORDER_PLAN_PARTLOC_KITS

IPCS_ORDER_PLAN

IPCS_ORDER_PLAN_HISTORY

IPCS_PART_MASTER

IPCS_SKU

Parameters

Name	Description	Default
PO_Performance360_DateType	Enables the Date Type display to be configured for the Spend History and Projection widget Options are: • Ordered • Shipped • Received • Available	Available

Demand Forecast Analysis

The data used to generate this widget is based on the following:

Article	Description
Analytical Object	N/A
Query Object	QO_SPM_Performance360_DemandForecastCompare
Data Source	PAI Foundation
Cab File	SPM_PAI_Foundation.cab
Query Object Primary Table	IPCS_FORECAST_DETAIL IPCS_DEMAND_HISTORY
Query Object Tables	IPCS_FORECAST_DETAIL IPCS_SLICE_INFO IPCS_PARTS_RELATIONSHIP IPCS_LOC_MASTER IPCS_PREPROCESSED IPCS_ACTIVE_NET_PREPROC IPCS_PROCESS_CONFIG IPCS_STREAM_CONFIG_DETAIL IPCS_DEMAND_STREAM IPCS_FORECAST_STREAM IPCS_DEMAND_HISTORY

Vendor Delivery Status

The data used to generate this widget is based on the following:

Article	Description
Analytical Object	N/A
Query Object	QO_SPM_Performance360_VendorDeliveryStatus
Data Source	PAI Foundation
Cab File	SPM_PAI_Foundation.cab
Query Object Primary Table	IPCS_ORDER_PLAN_HISTORY
Query Object Tables	IPCS_ORDER_PLAN_HISTORY IPCS_PART_MASTER IPCS_LOC_MASTER IPCS_VENDOR_LOC IPCS_VENDORS IPCS_STOCK_LEVEL

Excess by Location

The data used to generate this widget is based on the following:

Article	Description
Analytical Object	N/A
Query Object	QO_SPM_Performance360_ExcessByLocation
Data Source	PAI Foundation
Cab File	SPM_PAI_Foundation.cab
Query Object Primary Table	IPCS_EXCEPTION
Query Object Tables	IPCS_EXCEPTION IPCS_PREPROCESSED IPCS_PART_MASTER IPCS_LOC_MASTER IPCS_SKU

Was this helpful?