Calculated fields

In this section of the dimension options dialog, you can manage calculated fields. This fields are made of MDX formulas that can be simple arithmetic expressions or as complex as required.

This fields are not kept in the cube, although is possible to define them inside the cube, that is work for MS Analysis administrators, but you can save your cube view and next time you open it, the formulas will be defined again. If you open a new window from the same cube, since this fields are not in the cube proper, your calculated fields won't be available, only in the windows where you create them.

Once you have defined a calculated field, you can use it as if it was a regular field.

In this dialog you manage your calculated fields, you can create them or delete them at will.

Use the buttons Add to create a new field, Edit to modify it and Remove to delete it. In the grid are shown the field name, output format, solve order (explained later) and text that is the formula created. Once you created a calculated field, you can choose it on the Elements tab of this dialog like is shown below:

To create the new field, you use the calculated fields dialog:

Where you basically fill the following fields:

• Name: Name assigned to this calculated field.
• Fields: All the cube dimension members. Double click a field to insert it into the formula text.
• Format: Numeric format of the field. If using --- in the grid options dialog.
• MDX formulas: You can double click on a formula in the formula's list to insert into the formula text.
• Solve order: Sometimes you have formulas that should be evaluated before another ones. For example, adding averages, it's not the same the sum of averages than the average of the sums. The formulas will be evaluated in solve order
• Text: Here is the formula text. It must be a valid MDX expression, if not, the field won't be created.

See Microsoft documentation about MDX formulas. Click here.