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

Customer Geographic data in the Data Lake is composed of 4 different table views:

1. DIM_geo_zoneregion
2. DIM_regioncountry
3. DIM_countrymini_zone
4. DIM_minigeo_zone

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

Additional Info & Comments  

Tables & Attributes

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

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 

fullname	type	description
region_key	STRING
region_id	STRING
region_name	STRING
country_key	STRING
country_id	STRING
country_name	STRING
meta_source_system	STRING
inserted_date	TIMESTAMP
updated_date	TIMESTAMP
delete_flag	BOOLEAN

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

fullnametypedescriptionmini_zone_keySTRINGmini_zone_idSTRINGmini_zone

fullname	type	description
country_key	STRING
country_id	STRING
country_name	STRING	meta_source_system	STRING	inserted_date	TIMESTAMP	updated_date	TIMESTAMP	delete_flag	BOOLEAN

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

_name	STRING
meta_source_system	STRING
inserted_date	TIMESTAMP
updated_date	TIMESTAMP
delete_flag	BOOLEAN