Microsoft® SQL Server™ 2000 Analysis Services Step by Step

Working with a Cube

Dimensions are useful only when incorporated into a cube. A cube uses dimension hierarchies to summarize measures from a fact table. A cube must always have at least one dimension, at least one measure, and one (and only one) fact table.

To create a cube that combines measures from multiple fact tables, you can use a virtual cube, as explained in “Creating Virtual Cubes” in Chapter 4.

Use the Cube Editor

The Cube Wizard makes it easy for you to quickly put together a cube. But a cube has many properties that aren’t available when you use the wizard. So even if you use the wizard to create a cube, you’ll undoubtedly use the Cube Editor to refine it. In fact, it isn’t much harder to create a cube by using the Cube Editor ...