Analysis Services

Adding a Multiple-Column Measure to a Cube

A measure can contain multiple columns combined in an expression. For example, the Profit measure is the difference of two numeric columns: Sales and Cost.

When you build or update a cube in Cube Editor, you can add such a measure.

To add a multiple-column measure to a cube

Analysis Manager

Analysis Manager

After adding the measure, you must redesign storage options and aggregations for the cube using the Storage Design Wizard.

You must process the cube before end users can view its data. Depending on the size of the cube, processing may take considerable time.

See Also

Cube Editor - Data View

Cube Editor - Schema View

Measures

Processing Cubes

Storage Design Wizard