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 the Cube editor, you can add such a measure.
Caution If the cube contains multiple partitions, this procedure will delete them and add a single default partition.
To add a multiple-column measure to a cube
"sales_fact_1998"."store_sales"-"sales_fact_1998"."store_cost"
After adding the measure, you will need to redesign storage options and aggregations for the cube using the Storage Design wizard.
You must also process the cube before users can view its data. Depending on the size of the cube, processing may take considerable time. For more information, see Processing Cubes Using the OLAP Manager.