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