Chapter 6. Advanced OLAP Modeling

SSAS 2005 adds many exciting new capabilities to the modeling toolset for cubes and dimensions. Many of these features were added as a direct result of specific customer requests. The focus for the 2005 release is definitely on giving you much more flexibility to model your complex business scenarios than you had using SSAS 2000.

In this chapter, we'll continue to use the AdventureWorksDW sample to cover the new modeling techniques available to you in SSAS 2005. The chapter will cover the following topics:

  • Using multiple fact tables in a single cube

  • Modeling nonstar dimension types, including Many-to-Many (using intermediate fact tables), Fact (degenerate), Role-playing, Writeback, and more

  • Performing advanced dimension ...

Get Foundations of SQL Server 2005 Business Intelligence now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.