C H A P T E R  5

Image

Advanced OLAP Modeling with SSAS

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

  • Using multiple fact tables in a single cube
  • Modelin gnonstar dimension types, including many-to-many (using intermediate fact tables), fact (degenerate), role-playing, and writeback performing advanced dimension modeling, including modeling for either slowly or rapidly changing dimensions and adding custom error handling
  • Using the Business Intelligence Wizard for cubes and dimensions to easily enable writeback, semiadditive ...

Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition 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.

Start your free trial