Microsoft® SQL Server™ 2000 Analysis Services Step by Step

Chapter 4. Advanced Dimensions and Cubes

Chapter Objectives Estimated time: 2.5 hours
In this chapter, you’ll learn how to
Create custom member and rollup formulas. Manage very large, flat dimensions. Add drillthrough capabilities to a cube. Disable levels of a shared dimension. Prepare dimensions and cubes to allow dynamic changes. Create virtual cubes to combine or simplify cubes.

My brother works as a draftsman for an architectural firm. He told me recently that much of the challenge of modern home architecture comes from building unique, creative houses using nothing but prefabricated parts. I compared that to when one semiretired carpenter single-handedly framed our entire house 20 years ago. The carpenter didn’t use any prefabricated trusses ...