Hi all.
It seems like the migration wizzard changed the logic of ManyToMany
relations from OLAP2000 to OLAP2005. It seems like 2005 just pick the first
relation and stops there. Does anyone have a litle step by step info on how
to make such a dimention and connect it to the factatable. Here are some
data.


One factatable, CustomerID, InvoiceLineID, Price
CustomerGroup table. CustomerGroupID, CustomerGroupText

CustomerGroupConnectTable. CustomerID, CustomerGroupID

CustomerTable. CustomerID, CustomerName


I need a dimention with one hiearki going from ALL to CUSTOMERGROUP to
CUSTOMERNAME. The point is that if one customer is in several groups (can
happen) I want that customer to appear when I drilldown the corresponding
groups. As for now I cant make that happen for some reason. I get the
customer in one of the groups, but not all.

After this I want to connect this to the factatable trough the CustomerID.

Any ideas or links to nice wizards or other helpful sites.


thanx all.

I don't understand how you have modeled a many-to-many relationship
with AS2000, since it has no support for this.

Anyway, you can successfully buile a many-to-many relationship in
SSAS2005. I suggest you to read my paper on
http://www.sqlbi.eu/manytomany.aspx and eventually download the demo.
Your scenario is the first one on the paper, "Classical many-to-many".

Marco Russo
http://www.sqlbi.eu
http://www.sqljunkies.com/weblog/sqlbi

Geir Holme wrote: