Skip to main content
Calculated members are custom members of a hierarchy, defined by an MDX expression over the members the cube already contains. For example, an EUR + USD member on the Currency hierarchy aggregates the values of its EUR and USD members, so that the two currencies can be analyzed as one. New calculated members can either be saved on the cube or created in the scope of a single widget. This page covers the members saved on the cube. Save a member on the cube when several widgets, dashboards or users need it: its expression is then defined once, which keeps it easy to maintain and to evolve. For an ad hoc formula that only makes sense in one widget, or that should stay invisible to the other users of the cube, see add a calculation to a widget. A member saved on the cube becomes part of the hierarchy, nested under its parent member and listed alongside the hierarchy’s other members. Any widget of any dashboard with that hierarchy on one of its axes can then use it.
To be able to create or modify calculated members within the application, you must have the canUseCalculatedMembers permission.

​
How to open the Manage members popover

In the data model, right-click a hierarchy and select Manage members of {hierarchy name}. The popover lists the members of the hierarchy, which can be expanded and searched. Calculated members are recognizable by the fx icon before their name. Calculated members are not supported on virtual hierarchies, so the menu item is disabled on those.

​
How to create a calculated member

  1. Click the fx + button next to the search bar, which opens the editor on the right of the popover.
  2. Enter a Name. It must differ from the names of the other members sharing the same parent member.
  3. Leave Parent member on Root to add the member at the top of the hierarchy, or pick the member to nest it under. Only the members that can have children are offered, so on a hierarchy with a single level, Root is the only choice.
  4. Click one of the template buttons (Sum, Aggregate, Min, Max, Log, EXP, √ and xy) to insert its expression in the MDX editor below, then click members in the tree on the left to fill in the placeholders it left. Alternatively, use the MDX editor to type or paste your own expression.
  5. Click Save to save the calculated member to the cube, or Save and apply to also display it in the selected widget.
The Manage members popover, with the members of the Currency hierarchy on the left and the editor on the right defining an EUR + USD member

​
How to display calculated members in a widget

A widget only displays the calculated members of a hierarchy when its query asks for them. Save and apply updates the selected widget’s query so that it does, which makes the new member appear immediately. The other existing widgets do not display the new member, unless the hierarchy’s expression is wrapped in the AddCalculatedMembers() function in their MDX query. To automatically display all calculated members in the widgets built afterwards, turn on the mdx.doesIncludeCalculatedMembers setting.

​
How to edit a calculated member

  1. In the popover, right-click the calculated member and select Edit {member name}.
  2. Change its name, its parent member or its expression, then click Save, or Save and apply to also display it in the selected widget.
Renaming or moving a calculated member will cause errors in the dashboards where a widget refers to it.

​
How to delete a calculated member

  1. In the popover, right-click the calculated member and select Delete {member name}.
  2. A confirmation appears asking if you want to continue. If you do, click Delete.
Deleting a calculated member will cause errors in the dashboards where a widget refers to it.