Report Portal

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. 

Read more...

Tags: design, many-to-many

 

2007-2015 VidasSoft Systems Inc.