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