Page History

See also the BW page on GBU Master Data.

Data Object Definition

Organization data shows the allocation of sales to activity groups and GBUs, for purpose of analytics and reporting.

There 3 levels in the hierarchy: activities are grouped into a group of activity, which belongs to a GBU.

This data is available in the Data Ocean as of Q2 2023.

Data Model

Organization

data in the Data Lake is composed of 3 different table views:

1. DIM_

1. activity1

1. DIM_

1. group_

1. of_

1. activity

1. DIM_

1. gbu

Project Space: prj-data-pricing-dev
See how this entity relates to the others in the pricing data model here.

Additional Info &

Comments

• The GBU table also contains historical GBUs which are no longer a part of Solvay, for example Vinyls.
• Useful link Rules - Business structure

Data Flow

                        Image Added

• Extract Type(Snapshot/Delta): Full data will be extracted from source (SAP-BW) on a daily basis
• Schedule: Jobs will be scheduled to run everyday at 6:30PM CET    
• Mapping Document:

  Google Drive Live Link
  url https://docs.google.com/spreadsheets/d/166jR9q-KAuluj5Ait8fLw3FvFXkCE7x7_p-s893wpLU/edit#gid=807157089