C H A P T E R 5
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 ...