Working with Measures in a Cube

A cube must contain at least one dimension and at least one measure. The simplest measures are columns straight from the fact table, but it’s possible to use expressions to add additional measures to a cube. In many ways, measures in a cube behave like a dimension with a single level. Because of this, in some contexts you might see Measures presented as if it were simply one of the dimensions of a cube.

Create a Derived Measure

When you select a measure, a Source Column property appears on the Basic tab of the Properties pane. The Source Column property is similar to the Member Key Column and Member Name Column properties of a dimension level. As with those properties, it contains the name of a table and column ...

Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.