Skip to Content
0
Former Member
Oct 07, 2005 at 09:37 AM

n:m relation in a dimension?

29 Views

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