Below you can find the release notes for the Pricing Data Lake in GCP, with the latest production release always at the top.
This overview is intended to highlight what is new in each release but is not intended as full documentation on the final state of the data.
Please consult the Data Directory for the full detail on the data in the lake.
Release | Data Object | Description | Notes |
|---|---|---|---|
2023 Q3.4 | GBU | Organizational hierarchy within Solvay, including GBU, activity, and group of activity. | |
| Exchange Rates | Exchange rates from local currency to EUR. The Data Ocean dataset contains all exchange rate types used for financial report, while the Pricing Data Lake view will be limited to CAR3 and CAR4. | Exchange rate data available as in BW. Enhancements for Transparency planned for Q4.1 to include USD as a pivot currency and adjust forward rates. | |
| Market | Hierarchy of end use and market segments. | ||
| Region | Hierarchy of country groupings into zones, mini-zones, sub-regions and regions. | ||
| Customer | All master data attributes linked directly to customer accounts. This covers all customer types including soldtos and shiptos. | WP1, PF1 and Salesforce CORE data available. SpP extensions planned for Q4.2. | |
| Product | All master data attributes linked directly to product / materials. The dataset contains all material types from raw materials and intermediates up to finished goods and trading goods. This includes also attributes related to product hierarchy. | WP1, PF1 and Salesforce CORE data available. SpP extensions such as the H4 hierarchy are planned for Q4.2. The dataset today contains all materials existing in Solvay, including technical materials (spare parts) which are not relevant for Pricing. A more filtered dataset is planned for Q4.2 to reduce volume of data. There are a small amount of duplicates on the V_DIM_Material and V_DIM_Material_Group views due to data quality issues in the source systems. We are working on filtering these out by Q4.2. |