Many-to-Many: Which Dimension is Used?
User Rating: / 0
PoorBest 
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...

 

 

Pyramid Analytics