Analytics (with PAI 5.0.0.1) > Available PAI Dashboards > Performance 360 > Financial Bridge Analysis > Financial Bridge Analysis (Technical Specification)
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
• Part Family
• Part Number
• Part Type
• Pricing Stream
• Pricing Market
• Period
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?