AO_SPP_TransactionDataAnalysis
View dashboard associations
Build information
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 |
|
