Skip to main content

Calculated measures

Calculated measures are custom measures, often derived from existing measures stored in the cube. They can be created on the server, or in the UI.

Saved calculated measures are accessible from the Measures section of the data model, they can be recognized by the fx icon before their name. They can be added to a widget in exactly the same way as other measures, see add fields to a widget.

Calculated measures created and saved with Atoti UI are usable in Excel.

note

To be able to create or modify calculated measures within the application, you must have the canUseCalculatedMeasures permission.

Create a calculated measure​

To create a new calculated measure from the UI:

  • In the data model, in the header of the Measures section, click the "fx +" button. This will open the Create a calculated measure popover.
  • Enter a name for your calculated measure in the text box.
  • Just below, you will see several buttons, each representing a different type of calculated measure. Click one of these buttons to add a template to the MDX editor below.
  • A hint is displayed above the MDX editor telling you what is needed to complete the template, depending on which type of calculated measure you have chosen. Click a measure and/or hierarchy from the data model, to add them into the template.
  • Alternatively, you can use the MDX editor to type or paste your own calculated measure expression.
  • Click Save and apply when you are happy with the calculated measure expression and it will be saved to the cube as well as be added to the widget.
  • Alternatively, you can click on Save and the calculated measure definition will be saved to the cube but not added to the widget.
  • The saved calculated measure will now appear directly in the Data model, and can be added to any widget.

Calculated measures can also be added to a widget by modifying the MDX query directly using the Query tab, if it is included in your application.

tip

Click the green or red arrow buttons on the bottom left of the popover to increase or decrease the number of decimal places that will be displayed for your new calculated measure by default. Toggle the "%" button to choose whether or not the value is displayed as a percentage.

The format of the value can be changed from the Style tab after creation, for an individual widget.

Edit a calculated measure​

To edit a calculated measure:

  • You can right-click on the measure in the Data model and select Edit {measure name}.
  • Use the MDX editor to make any changes to the calculated measure expression, then click Save.

Rename a calculated measure​

To rename a calculated measure:

  • In the data model, right-click the name of the calculated measure to open the context menu.
  • Select Edit {measure name}.
  • Change the name in the top input box under Calculated measure name.

Saved calculated measures cannot be renamed for individual widgets, they can only be renamed globally from the data model.

caution

Renaming a saved calculated measure will cause errors in dashboards where a widget refers to this calculated measure.

Delete a saved calculated measure​

  • In the data model, right-click the name of the calculated measure to open the context menu.
  • Select Delete {measure name}.
  • A popconfirm will apppear asking if you want to continue, if you do, click Delete.
caution

Deleting a saved calculated measure will cause errors in dashboards where a widget refers to this calculated measure.