Financial Bridge Analysis (Technical Specification)

Analytics (with PAI) > Performance 360 > Financial Bridge Analysis > Financial Bridge Analysis (Technical Specification)

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

Analytical Object

AO_SPP_FinancialBridgeAnalysis

Query Object

QO_SPP_FinancialBridgeAnalysis

Data Source

PAI Foundation

Cab File

SPP_PAI_Foundation.cab

Parameters

Name	Description	Default
PO_CurrencyId	The ID of the currency that is used for the display	1
PO_SPP_FincAnalysisHistMonths	The number of historical months to be monitored	36

Predecessor Jobs

AutoPilot

Build Type

The following build types are supported:

• Full

Build Frequency

After the Monthly Financial process is run. For example:

• Monthly Financial process is run daily — Analytical Object rebuilt daily

• Monthly Financial process is run weekly — Analytical Object rebuilt weekly

• Monthly Financial process is run monthly — Analytical Object rebuilt monthly

Dimensions

• Part Family

• Part Number

• Part Type

• Pricing Stream

• Pricing Market

• Period

Measures

Measure	Mathematical Function
Current Price	Average of Current Price
Previous Price	Average of Previous Price
Current Cost	Average of Current Cost
Previous Cost	Average of Previous Cost
Distinct Dates	Distinct Count of Current Date
Current Volume	Sum of Current Volume
Previous Volume	Sum of Previous Volume
Current Revenue	Sum of Current Revenue
Current Profit	Sum of Current Profit
Previous Revenue	Sum of Previous Revenue
Previous Profit	Sum of Previous Profit
Cost Change Profit	Sum of Cost Change Profit((Previous Price - Current Cost) * Previous Volume)
Price Change Profit	Sum of Price Change Profit((Current Price - Previous Cost) * Previous Volume)
Demand Change Profit	Sum of Demand Change Profit((Previous Price - Previous Cost) * Current Volume)
Price Change Revenue	Sum of Price Change Revenue(Current Price * Previous Volume)
Demand Change Revenue	Sum of Demand Change Revenue(Previous Price * Current Volume)
Previous Margin	Previous Profit / Previous Revenue
Cost Change Margin	Cost Change Profit / Previous Revenue
Cost Change Margin Impact	Cost Change Margin - Previous Margin
Price Change Margin	Price Change Profit / Price Change Revenue
Price Change Margin Impact	Price Change Margin - Previous Margin
Demand Change Margin	Demand Change Profit / Demand Change Revenue
Demand Change Margin Impact	Demand Change Margin - Previous Margin
Sales Mix Change Margin Impact	Current Margin-Previous Margin - Cost Change Margin Impact - Price Change Margin Impact - Demand Change Margin Impact
Current Margin	Current Profit / Current Revenue
Margin Change	Current Margin - Previous Margin
Cost Change Profit Impact	Cost Change Profit - Previous Profit
Price Change Profit Impact	Price Change Profit - Previous Profit
Demand Change Profit Impact	Demand Change Profit - Previous Profit
Sales Mix Change Profit Impact	Current Profit - Previous Profit - Cost Change Profit Impact - Price Change Profit Impact - Demand Change Profit Impact
Profit Change	Current Profit - Previous Profit
Price Change Revenue Impact	Price Change Revenue - Previous Revenue
Demand Change Revenue Impact	Demand Change Revenue - Previous Revenue
Sales Mix Change Revenue Impact	Current Revenue - Previous Revenue - Price Change Revenue Impact - Demand Change Revenue Impact
Revenue Change	Current Revenue - Previous Revenue

Was this helpful?