Advanced OLAP Modeling with SSAS

  • Guy Fouché
  • Lynn Langit


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

  • Modeling nonstar 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 measures, account/time/dimension intelligence, unary operators, custom member formulas, and attribute ordering.


Dimension Table Measure Group Fact Table Dimension Attribute Business Requirement 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Guy Fouché and Lynn Langit 2011

Authors and Affiliations

  • Guy Fouché
  • Lynn Langit

There are no affiliations available

Personalised recommendations