The Many 2Many Revolution: Advanced Dimensional Modeling with SQL Server Analysis Services 2005

by Marco Russo

0 ratings • 0 reviews • 0 shelved
Book cover for The Many 2Many Revolution: Advanced Dimensional Modeling with SQL Server Analysis Services 2005

Bookhype may earn a small commission from qualifying purchases. Full disclosure.

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