OVERVIEW OF QUERIES USED PER PAGE :
Sources per page (update Sept 2022)
Others sources:
| Query Type | Query Technical | Information in Pricing Dashboard | Already Live |
|---|---|---|---|
| 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 & KPIs detailed information
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