Create a calculated member

A Calculated Member is a reusable formula whose value is calculated using other member values, mathematical calculations, and logical operations. The member is dynamically calculated at the time of use.

Steps

  1. Click New resource > Calculated Member.

  2. Drag a measure from the Dimension Tree to the Formula placeholder.

  3. Select the operation you wish to perform (e.g., +, =, >, If , etc.).

  4. Drag another measure from the Dimension Tree to the Formula placeholder.

  5. Repeat steps 2-4 until your formula is complete.

  6. Optional steps

    1. Use the Number Format text-box to specify a format for the calculated member's numeric value to be returned.

    2. Calculation Order can be specified, but the default Post Aggregation option will be used if left blank.

    3. Specify the Calculated Member display location on the Dimension Tree with any of the following actions:

      1. Directly under a specific hierarchy or member

        1. Drag-and-drop a hierarchy or member from theDimension Treeinto theParent hierarchy or memberplaceholder. The Calculated Member will be organized under this parent in theDimension Tree.

      2. Within a specific measure group

        1. To store a Calculated Member under a specific measure group, drag a measure group into the parent measure group placeholder.

      3. Within a subfolder

        1. Specify the desired folder name in the display folder text box. The folder is displayed under the specified parent hierarchy and/or measure group.

  7. Click Save. Specify a name and location and click OK.

Note

Calculated Members can also be created by hovering over a placeholder on an analysis and clicking Create a custom formula.

In this section: