|Many-to-Many: Which Dimension is Used?|
|Written by Vincent Rainardi|
|Sunday, 29 May 2011 21:20|
In SSAS, it is possible for a M2M to have 2 paths. The first one is through Dim1 and second one is through Dim2. In this case, which path will be used by M2M? I've come across this question about 2 years ago, and have been delaying finding the answer until now. So here it is.
Ah before I start, 2 things. 1) This post is related this [link] post I wrote 2 days ago: Many to Many Is Not Always Right. 2) Thank you to Robert [last name] for bringing this up. I came across it for the first time 2 years ago, and I've always wanted to find out.Read more...