How to add a multiple-column measure to a cube

To add a multiple-column measure to a cube

1. In the Analysis Manager tree pane, right-click the cube, and then click Edit.
   
   
2. In the Cube Editor tree pane, right-click the Measures folder, and then click New Measure. Use the Insert Measure dialog box to select one of the columns for the measure.
   
   
3. In the Cube Editor tree pane, ensure the new measure is selected.
   
   
4. Expand the properties pane, and in the Source Column value, type an expression containing the columns. For example:

   "sales_fact_1998"."store_sales"-"sales_fact_1998"."store_cost"
   

5. On the File menu, click Save.

See Also

Adding a Multiple-Column Measure to a Cube