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.


Deployment Status

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_activity1
  2. DIM_group_of_activity
  3. DIM_gbu

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


Tables & Attributes

View ID: V_DIM_activity1

View ID: V_DIM_group_of_activity

View ID: V_DIM_gbu


Additional Info & Comments


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