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 → 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