Page History

Data Object Definition

Geographic data shows the grouping of countries into a hierarchy of regions and zones, for purpose of aggregating sales data for analytics and reporting.

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

Data Model

Geographic

data in the Data Lake is composed of

4 different table views:

1. DIM_region
2. DIM_

1. country

1. DIM_

1. mini_

1. zone

1. DIM_

1. geo_

1. zone

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

Additional Info & Comments  

Below is the overview over the structure of geographic hierarchy. 

    Image Added

• Countries are logically divided into below 4 Geographic Zones based on geography, mostly aligning with the location Solvay plant/sites resides.
          ASIA PACIFIC
          EUROPE
          LATIN AMERICA
          NORTH AMERICA
• Geo Zones are further divided into Mini Zone
• Each Mini Zone will have one or many countries under it
• Each country is further divided into smaller Regions 

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 <<>>hrs 
• Mapping Document:

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

Tables & Attributes

View ID: prj-data-pricing-dev.DataOcean.V_DIM_

region 

View ID: prj-data-pricing-dev.DataOcean.V_DIM_

country