| Title | : | The Many 2Many Revolution: Advanced Dimensional Modeling with SQL Server Analysis Services 2005 |
|---|---|---|
| Author | : | Marco Russo |
| Release | : | 2011-03-30 |
| Kind | : | ebook |
| Genre | : | Computers, Books, Computers & Internet |
| Size | : | 3436817 |
| Analysis Services 2005 (SSAS 2005) introduced the capability to handle many-to-many relationships between dimensions. At a first glance, you may tend to underscore the importance of this feature: after all, Analysis Services 2000 and many other OLAP engines do not offer many-to-many relationships. Yet, its lack did not limit their adoption and, apparently, only a few businesses really require it. However, as this paper shows, the UDM (Unified Dimensional Model) can leverage many-to-many relationships helping you to present data from different perspectives that are not feasible with a traditional star schema. This opens a brand new world of opportunities that transcends the limits of traditional OLAP. We will explore many different uses of many-to-many relationships that give us more choices to model effectively business needs. |
