View Source

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)

Pricing Front End - 11240 > Data Sources Information > image2022-9-29_12-23-10.png

Back to Pricing Dashboard User Documentation - Main Page