Global Group Price Analysis - Technical Specification
The data used to generate this dashboard is based on the following:
Analytical Object | AO_SPP_GroupPriceAnalysis |
Query Object | QO_SPP_GroupPriceAnalysis |
Data Source | PAI Foundation |
Cab File | SPP_PAI_Foundation.cab |
Parameters | None |
Predecessor Jobs | AutoPilot |
Build Type | None |
Build Frequency | After the Group Price Analysis process is run. For example: • Group Price Analysis process is run daily — Analytical Object rebuilt daily • Group Price Analysis process is run weekly — Analytical Object rebuilt weekly • Group Price Analysis process is run monthly — Analytical Object rebuilt monthly |
| • Location • Part Family • Part Number • Part Type • Price Class • Price Line • Pricing Market |
| Measure | Mathematical Function |
|---|
Current Margin | Average of Current Margin | Last Month Profit | Sum of Last Month Profit | Last Month Revenue | Sum of Last Month Revenue | Last Year Profit | Sum of Last Year Profit | Last Year Revenue | Sum of Last Year Revenue | MOM Profit Growth % | iif([Measures].[Previous Month Profit] < 0.0, (([Measures].[Last Month Profit]-[Measures].[Previous Month Profit])/(0.0 - [Measures].[Previous Month Profit])), (([Measures].[Last Month Profit]-[Measures].[Previous Month Profit])/([Measures].[Previous Month Profit]))) | MOM Revenue | Average of Month Over Month Revenue | MOM Revenue Growth % | ([Measures].[Last Month Revenue]-[Measures].[Previous Month Revenue])/([Measures].[Previous Month Revenue]) | Previous Month Profit | Sum of Previous Month Profit | Previous Month Revenue | Sum of Previous Month Revenue | Previous Year Profit | Sum of Previous Year Profit | Previous Year Revenue | Sum of Previous Year Revenue | Standard Cost | Average of Standard Cost | Standard Price | Average of Standard Price | YOY Profit Growth % | iif([Measures].[Previous Year Profit] < 0.0, (([Measures].[Last Year Profit]-[Measures].[Previous Year Profit])/(0.0 - [Measures].[Previous Year Profit])), (([Measures].[Last Year Profit]-[Measures].[Previous Year Profit])/([Measures].[Previous Year Profit]))) | YOY Revenue | Average of Year Over Year Revenue | YOY Revenue Growth % | ([Measures].[Last Year Revenue]-[Measures].[Previous Year Revenue])/([Measures].[Previous Year Revenue]) |
|
