Analysis Services: Should you use many-to-many dimensions?
For starters, please note that I am not saying not to use many-to-many (m:n) dimensions in Analysis Services. This is an excellent feature that enables you to relate multiple leaf-level values to multiple parents. Many-to-many relationships are used heavily in many business scenarios ranging from sales to accounting to healthcare. But at times there may be query performance issues when dealing with a large number of many-to-many relationships and perceived accuracy issues. The purpose of this technical note is to provide background and logical business scenarios of how many-to-many dimensions work and their potential perceived accuracy issues.
Tags: design, many-to-many