Hello,
we have a conceptual problem. There countries and groups of countries (EU10, EU15, etc.) Each country can belong to several groups. A Group can contain different countries.
How can we build a dimension of this?
Assigning a record of the fact-table to a country-group is difficult, because it could belong to more than one country-groups.
Tobias