Skip to main content

​
nation_group

SQL table: MASTER.NATION_GROUP Reference table of nation groups — supranational organisations, blocs, and alliances that nations belong to (e.g. UN, G7, EU, NATO). Each row represents one group with its type, hierarchical parent, and descriptive attributes. Use this cube to filter or group nation-level fact data by membership in a particular bloc or organisation.

​
Joins

​
Dimensions

​
Measures

​
Aliased cubes

The following aliased cubes share MASTER.NATION_GROUP and are used to resolve foreign keys or self-joins. Do not query directly.
  • nation_group_parent — resolves the parent-child self-join in nation_group.
  • nation_group_un_region — resolves the UN_REGION FK on the nation cube.
  • nation_group_un_sub_region — resolves the UN_SUB_REGION FK on the nation cube.
  • nation_group_world_bank_region — resolves the WORLD_BANK_REGION FK on the nation cube.