Hello everybody, guess what! I got good and bad news, the good news first, I found what I was looking for, in this link (great!)

Many-to-many dimensions (by marcorusso)

Now the bad news, apparently there is a bug with this exciting feature of SSAS 2005, I don't have SSAS 2008 so I kindly ask any of you to see if this approach works on the new version of SSAS, anyway, the bug is described (by the same author) in the following link.

Wrong calculation for unary operator with many-to-many relationships by marcorusso

I think a workaround to this bug could be playing with the "signs law" and do a balance sheet using only the "-" sign (as far as the author says, it work suitable using only the minus sign), challenging isn't it? So the issue is not solved yet...

Best regards

--

Douglas