Naar de inhoud
eBook Charts
NL
The Many 2Many Revolution: Advanced Dimensional Modeling with SQL Server Analysis Services 2005

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

Marco Russo

€ 1,99

Kopen bij Amazon Bekijk in Apple Books

Liever op papier? Alle uitvoeringen bij Amazon →

Prijs in Apple Books. Bij Amazon kan die afwijken.

Verschenen
Genres
ComputersComputers en internet

Beschrijving

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.