You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

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 or changed 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 each of the data objects in the lake.


Release

Data ObjectDescriptionNotes

2023 Q3.4

Oct 11, 2023

 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.

  • No labels