Chapter 3. Dimension and Cube Editors

Chapter Objectives Estimated time: 2.5 hours
In this chapter, you’ll learn how to

  • Use the Dimension Editor to create shared dimensions.

  • Use the Cube Editor to create cubes and private dimensions.

  • Modify dimension and level properties.

  • Use specialized features of Time and parent-child dimensions.

  • Create expressions for member keys, member names, and measures.

  • Create calculated members.

A friend of mine designs autopilot software for a large commercial airplane manufacturing company. He once told me that the autopilot software could perform an instrument landing just fine, completely without a pilot, but that the FAA requires the pilot to be in control anyway. Somehow, I’m thankful for that FAA regulation.

Creating ...

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.

Start your free trial