Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Many to Many

0 views
Skip to first unread message

Geri Reshef

unread,
Dec 16, 2009, 10:26:56 AM12/16/09
to
I'm trying to understand and implement the Many to Many solution in SSAS
2008.

In the tutorial of Microsoft - the intermediate table (between the fact
table and the dimension table) has 3 fields Primary Key:
the 2 Fields of the fact table primary key
and 1 field of the dim table PK..
That make sense and thus things are going on also in a relational database.

My question: Is it a must? Always in Many2Many relationship in OLAP the
intermediate table will has a PK combined of the PKs of the two tables
related to it 1:N?
The example in the above mentioned tutorial works fine,
but whe I try to implement it in a different environment where the
intermediate table is not related to the Fact PK - it doesn't work..


Marco Russo

unread,
Dec 17, 2009, 5:25:35 AM12/17/09
to

Look at this: http://www.sqlbi.com/manytomany.aspx
It is a document dedicated to this feature (it also explores advanced
modeling techniques based on this type of relationship).

Marco Russo
http://www.sqlbi.com
http://sqlblog.com/blogs/marco_russo

0 new messages