Skip to Content
author's profile photo
Former Member

n:m relation in a dimension?

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Oct 07, 2005 at 09:54 AM

    Probably a hierarchy can be used to model the country-->group relationship (where multiple values/range are allowed). In which case, you will get all the country records reported in all possible groups.

    If you are getting the data with both info (country and group), you should think of putting them in separate dimensions.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 07, 2005 at 10:00 AM

    Hi Tobias,

    I think that it's better to have in your cube only Country object and to manage Group Country object as attribute of the first one!

    Bye,

    Roberto

    Sorry, attribute management is not possible...I didn't consider the sentence "country can belong to several groups"....

    Message was edited by: Roberto Negro

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Tobias,

      I would follow Ajay's suggestion, having just the country in the cube and a hierarchy on the country object.

      regards

      Siggi