OVERVIEW OF QUERIES USED PER PAGE :
Sources per page (updated Oct 2023)
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 |
| P&L Data Corrections | Manual source file managed by Finance | Corrections to P&L which can not be directly applied in BW/SAP | 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”.
The standard refresh schedule:
| Dashboard refresh (last 2 months historical) | 8 AM CET daily excl. weekends 2 AM CET daily excl. weekends (only SFDC data for campaign monitoring) |
| Manufacturing Variable Cost query | 8th of each month (uploaded in the query on the 7th of each available month) |
| Data reload (Full refresh of 2 year historical) | Once a week over the weekend |
| Forward Revenue query | To be updated |
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 → Automatically calculated by the system using the following rules (executed in order):
- 1. If Account Team Cluster equals to null/Empty, then Market Cluster = 'Not identified'. If not, the system goes to the next rule
- 2. If Account Team Cluster equals to 'Channel Partners & Digital Sales' then Market Cluster = 'Channel Partners & Digital Sales'. If not, the system goes to next rule
- 3. If End Use equals to null/Empty then Market Cluster = 'Not Identified'. If not, the system goes to the next rule
- 4. If End Use not equal to null/Empty then we use the end use mapping to get the Market Cluster for each specific End Use (using End_Use_Mapping__mdt.) If not, the system goes to the next rule
- 5. If End Use equals to null/Empty then Market Cluster = 'Not identified'
- Product H4/L4 → combination of Product H4 for SpP with mapping from Icare, Product Level 4 for others GBUs