Analytics (with PAI) > Performance 360 > Transaction Data Analysis > Transaction Data Analysis (Technical Specification)
Transaction Data Analysis (Technical Specification)
The data used to generate this dashboard is based on the following:
Price Book Analysis
The data used to generate this mini-dashboard is based on the following:
Analytical Object
AO_SPP_TransactionDataAnalysis
Query Object
QO_SPP_TransactionDataAnalysis
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
Predecessor Jobs
AutoPilot
Build Type
The following build types are supported:
• Full
Build Frequency
After new transaction data is entered.
* 
If transaction data is entered nightly/weekly/monthly, the cube for this dashboard should be build accordingly.
• Part
• Location
• Customer
• Transaction Number
• Transaction Period
• Pricing Sales Order Type
• Part Family
Measure
Mathematical Function
Sales Price
Average of Sales Price
List Price
Average of CustomPrice1
DNet Price
Average of StandardPrice
Sales Quantity
Sum of SalesQuantity
Cost
Average of StandardCost
Total Sales Revenue
Sales Price * Sales Quantity
Total DNet Revenue
DNet Price * Sales Quantity
Total Retail Revenue
List Price * Sales Quantity
Total DNet Profit
(DNet Price - Cost) * Sales Quantity
Total Sales Profit
(Sales Price - Cost) * Sales Quantity
Wt Avg List Price
Total Retail Revenue / Sales Quantity
Wt Avg DNet Price
Total DNet Revenue / Sales Quantity
Wt Avg Sales Price
Total Sales Revenue / Sales Quantity
Wt Avg Cost
Total Cost / Sales Quantity
Pocket Price
Wt Avg Sales Price - Wt Avg Cost
Additional Discount
Wt Avg DNet Price - Wt Avg Sales Price
Dealer Discount
Wt Avg List Price - Wt Avg DNet Price
Total Cost
Cost * Sales Quantity
Dealer Discount %
Dealer Discount] / Wt Avg List Price
Additional Discount %
Additional Discount / Wt Avg DNet Price
Pocket Margin
Total Sales Profit/Total Sales Revenue
Price Book Stream Financials
The data used to generate this mini-dashboard is based on the following:
Analytical Object
AO_SPP_PriceBookStreamFinancials
Query Object
QO_SPP_PriceBookStreamFinancials
Data Source
PAI Foundation
Cab File
PriceBookAnalysisDashboard.cab
Parameters
Name
Description
Default
PO_CurrencyId
The ID of the currency that is used for the display
1
Predecessor Jobs
AutoPilot
Build Type
The following build types are supported:
• Full
Build Frequency
After policies that are linked to the price book are run and the outputs are uploaded.
* 
Since policies will most likely be run on a daily basis it is recommended that the analytical object for this dashboard should be built on a nightly basis. If data will be tracked on a weekly basis then the analytical object can be rebuilt weekly.
• Location
• Policy Financials
• Policy Workflow Status
• Stream Financials
Measure
Mathematical Function
Policy New Revenue
Sum of Policy New Revenue
Price Action New Revenue
Sum of Price Action New Revenue
Price Book New Revenue
Sum of Price Book New Revenue
Policy New Profit
Sum of Policy New Profit
Price Action New Profit
Sum of Price Action New Profit
Price Book New Profit
Sum of Price Book New Profit
Price Book Uploaded SKUs
The data used to generate this mini-dashboard is based on the following:
Analytical Object
AO_SPP_PriceBookUploaded
Query Object
QO_SPP_PriceBookUploaded
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
Predecessor Jobs
AutoPilot
Build Type
The following build types are supported:
• Full
Build Frequency
After policies that are linked to the price book are run and the outputs are uploaded.
* 
Since policies will most likely be run on a daily basis it is recommended that the analytical object for this dashboard should be built on a nightly basis. If data will be tracked on a weekly basis then the analytical object can be rebuilt weekly.
• Location
• Part Number
• Policy Workflow Status
• Price book
• Price Effective Date
• Pricing Folder
• Uploaded By
• Uploaded Date
Measure
Mathematical Function
New Standard Price
Sum of New Standard Price
New Volume Price
Sum of New Volume Price
New Expedite Price
Sum of New Expedite Price
New Refurbished Price
Sum of New Refurbished Price
New Damaged Price
Sum of New Damaged Price
New Custom Price 1
Sum of New Custom Price 1
New Custom Price 2
Sum of New Custom Price 2
New Custom Price 3
Sum of New Custom Price 3
New Custom Price 4
Sum of New Custom Price 4
New Custom Price 5
Sum of New Custom Price 5
New Custom Price 11
Sum of New Custom Price 11
New Custom Price 12
Sum of New Custom Price 12
New Custom Price 13
Sum of New Custom Price 13
New Custom Price 14
Sum of New Custom Price 14
New Custom Price 15
Sum of New Custom Price 15
New Custom Price 16
Sum of New Custom Price 16
New Custom Price 17
Sum of New Custom Price 17
New Custom Price 18
Sum of New Custom Price 18
New Custom Price 19
Sum of New Custom Price 19
New Custom Price 20
Sum of New Custom Price 20
New Profit
Sum of New Profit
New Revenue
Sum of New Revenue
New Volume
Sum of New Volume
Was this helpful?