Initial variable list for which the data extracted from transparency to price optimization engine (Novecare)
Transparency:
1. For Novacare, we use below aggregation logic
a. Data will be aggregated on Shipto + Material +incoterm combination to derive CPC combination
b. Further aggregate on Order number to consider adjustments
c. Take the latest order by delivery date to derive Last Invoice Price (€/KG) attribute (Ayoub to conform the exact logic to derive "Last Invoice Price (€/KG)")
2. Rest of the attributes part of Transparency Feature extract will be a 1:1 mapping to COPA03 query
3. All the attributes part of Forecast extract will be a 1:1 mapping to QV_BW_QRY_CPCOPC07_0001
Last Invoice Price (€/KG)" derivation logic, confirming if there are any currency and UOM conversion in Transparency ?
Any data quality issues?
"Last invoice price" below has been generated in transparency dashboard based on the last invoice generated per CPC. what is the rule for the forecast?
https://docs.google.com/spreadsheets/d/1w4NqqxUPwFVvZ0P9wTa1R0T61wJseV00qoHIc9IlKTw/edit#gid=0
Price optimization (Novecare):
1. the sales by sites where solvay is 100% shareholder ?
2. Should we include internal sales (Ex: Sales between Novecare to SPP)