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

Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step 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.