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.
- ISBN10 1257247026
- ISBN13 9781257247028
- Publish Date 3 October 2011
- Publish Status Active
- Publish Country US
- Imprint Lulu.com
- Format eBook (OEB)
- Language English