Calculated Measures

To add a calculated measure:





Editing Saved Calculated Measures

If you chose Private or Public Security option, the new calculated measure will appear in the Field List. You or other users can use the measure by dragging it from the field list into the Drop Area.

The saved calculated measure will also be accessible by clicking on "Open Saved Calculation" folder icon.

You can also select a named set. It will be converted to a member using Aggregate MDX function. For example, "Top 10 customers" named set will be converted to a single member that would represent all 10 customers.




Calculated Members

Calculated Member can be added to dimensions instead of measures. To create a Calculated Member:


The calculation will show up under "Calculations" node in the top of the filter box. To open a saved calculated member open "Saved Calculation" dialog mentioned above.