O'Reilly logo

Foundations of SQL Server 2005 Business Intelligence by Lynn Langit

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required