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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
