MicroStrategy ONE

Create Calculated Members in Hierarchy Reports Using MDX Expressions

You can create calculated members in hierarchy reports using MDX expressions.

  1. Open the dossier you want to modify.
  2. Right-click an element in the grid and select Calculated Member. The Calculated Member dialog opens. The parent element appears in Parent.
  3. In Name, enter a name for the calculated member.
  4. In the MDX Expression, enter arguments for the Apply Simple function. This function allows you to enter an MDX expression, within the quotes, to create a calculated member. You can type arithmetic operators (such as + and -) and values directly in the expression.

    5. Create a calculated member for the previous year.

    ApplySimple("ParallelPeriod([Date].[Calendar].[Calendar Year], 1, [Date].[Calendar].[Calendar Year].[CY 2018])")

  5. You can add hierarchical elements from the left pane to the MDX expression. Expand the hierarchies in the left pane to locate the hierarchical elements you want to add. Then, double-click or drag them to the MDX Expression pane.
  6. The targeted element is the default parent. To change the parent, click Set Parent next to the hierarchical element you want to assign as the parent.
  7. If you need to delete the expression and begin again, click Clear.
  8. Click Save.