Every cube can contain several measures. A measure can either be derived from a column of the fact table or from a MDX formula, further referenced as calculated member.
To add a measure:
Select the cube you want to add the measure to.
Click on
to add a measure to the cube.Enter the following information:
In this field ...
Do this ...
Name
Enter a measure name.
Caption
Enter the measure caption.
Aggregator
Select the aggregate function (sum, count, min, max, avg, distinct-count).
Value
Either select the column the measure is based on or write an expression.
To add a calculated member:
Select the cube you want to add the measure to.
Click on
to add a calculated member to the
cube.Enter the following information:
In this field ...
Do this ...
Name
Enter a measure name.
Caption
Enter the measure caption.
Dimension
Enter the dimension name. Measures should be default value.
Visible
Select if calculated member should be visible or not.
Formula
Enter the formula for the calculation.
Format
Enter the format.