| Denny Lee 2006-01-26, 4:58 pm |
| Hi there,
You can get more information about many-to-many relationships from my blog
entry at:
[url]http://spaces.msn.com/members/denster/Blog/cns[/ url]!1pvF91EMBBNxnTG
lLGUgGehg!283.entry
In the end, what many-to-many relationship means is that a particular value
within a hierarchy could have multiple parent and/or child relationships
associated with it. For example, if you were creating a geographic
dimension, the country "Germany" can belong to a Western Europe hierarchy
and also a EU hierarchy. While many relationships have just a one-to-one or
one-to-many relationship (e.g. time, product categories, etc.), there are
quite a few that have many-to-many relationships (hierarchy within a
company, geographic hierarchies that include political and economic
attributes, etc.). Using many-to-many relationships within OLAP/SQL should
be used in the context of what of the data.
--
HTH!
Denny Lee
< dennyglee_at_hotmail
_dot_com>
Blog at:: http://spaces.msn.com/members/denster/
"Baerbel Zimmermann" <baerzi@freenet.de> wrote in message
news:Ozak1KqIGHA.2708@tk2msftngp13.phx.gbl...
> Hi,
>
> Can anybody explain me what the meaning of the Relationship "many to
> many" is? Where I can find an example for that or in which case I must
> use this kind of Relationship?
>
> Thanks
> Bärbel
>
>
> *** Sent via Developersdex http://www.droptable.com ***
|