Price Book Analysis - Technical Specification
These are the mini-dashboards that comprise the Price Book Analysis dashboard.
Price Book Analysis
The data used to generate this mini-dashboard is based on the following:
Analytical Object | AO_SPP_PriceBookAnalysis |
Query Object | QO_SPP_PriceBookAnalysis |
Data Source | PAI Foundation |
Cab File | SPP_PAI_Foundation.cab |
Parameters | None |
Predecessor Jobs | AutoPilot |
Build Type | None |
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 Workflow Status • Price Book • Pricing Folder |
| Measure | Mathematical Function |
|---|
SKU Count | Count of Policy ID | SKUs Uploaded | Count of Upload ID | SKUs on Price Action | Count of approval workflow IDs | SKUs at Upload Level | Count of approval level IDs at upload level | SKUs at Approval Level | Count of approval level IDs at non upload level | SKUs on Hold | Count of SKUs marked as hold | Duplicate SKUs | SKU Count - Distinct count of SKUs | SKUs Uploaded (pct) | SKUs Uploaded / SKU count | SKUs on Price Action (pct) | SKUs on Price Action / SKU count | SKUs to be Priced (pct) | SKU Count - (SKUs Uploaded (pct) + SKUs on Price Action (pct)) | Price Book New Revenue | Sum of price book new revenue | Policy New Revenue | Sum of policy new revenue | Price Action New Revenue | Sum of price action new revenue | Price Book New Profit | Sum of price book new profit | Policy New Profit | Sum of policy new profit | Price Action New Profit | Sum of price action new profit | Target Revenue | Target revenue of price book | Revenue Shortfall | Target revenue - (Price Book New Revenue - Price Action New Revenue) | Target Profit | Target profit of price book | Profit Shortfall | Target profit - (Price Book New Profit - Price Action New Profit) |
|
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 | None |
Predecessor Jobs | AutoPilot |
Build Type | None |
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 | None |
Predecessor Jobs | AutoPilot |
Build Type | None |
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 |
|
