Business Intelligence: Many-to-Many Revolution 2.0

SQL Server Analysis Services introduced modeling many-to-many relationships between dimensions in version 2005. At a first glance, we may tend to underestimate the importance of this feature: after all, many other OLAP engines do not offer many-to-many relationships. Yet, this lack did not limit their adoption and, apparently, only a few businesses really require it.

In this paper, you will read about many different uses of many-to-many relationships in both BISM Multidimensional and BISM Tabular, in order to give you more choices to model effectively business needs.