Back to Pricing Dashboard User Documentation - Main Page
QUERIES USED IN THE DASHBOARD :
| Query Type | Query Technical | Information in Pricing Dashboard | Already Live |
|---|---|---|---|
| P&L | QVSBS_BW_QRY_CPCOPA03_0001 (since June 2022) | Sales, Volumes, Costs, Margin (ICM adjusted information WP1 – PF1) | Yes |
| Budget | SpP : Icare Others : QV_BW_QRY_MVSDSO61_0001 | Budget | Yes |
| Order book | QVSD_BW_QRY_MVSDSO41_SD004 | Order price, quantities, order type | Yes |
| Manufacturing Variable Costs | QV_BW_QRY_CPCOPC04_0001 | Details of manufacturing VC past & future costs | Yes |
| Sales Forecast Revenue | QV_BW_QRY_CPCOPC07_0001 | Forecasted prices and quantities | No |
| CRM Icare | None (direct feed from Icare) | Price setting, Price execution tracking & Pricing Campaign | Yes |
| CRM CORE | None (direct feed from CORE) | Price setting, Price execution tracking & Pricing Campaign | No |
| P&L Data (additional) | Manual source file (xlsx) data from 2021 | Sales historical data for Composite Materials (CM)* (before migration to SAP WP1) | Yes |
*Since quantity data is missing in Composite Materials flat files, "1" is automatically added to the rows initially without a quantity data, and these rows are tagged. When one of these rows is in the selection, a warning message appears: “Quantity is missing for some of CM sales in the selection”.
Dimensions that have been reworked in the dashboard:
- GBU Region → for SpP based on ECCO Region in Icare, for Novecare & Technology Solution, Mexico is being part of LATAM instead of NAM, Aroma = Region H1
- Market Cluster for SpP → Mapping from Icare RULE TO BE UPDATED HERE
- Product H4/L4 → combination of Product H4 for SpP with mapping from Icare, Product Level 4 for others GBUs
OVERVIEW OF QUERIES USED PER PAGE :
Sources per page (update Sept 2022)
Back to Pricing Dashboard User Documentation - Main Page