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 ...