• Article

How to: Add a Calculated Member for an Analysis Services MDX Query (Report Builder 2.0)

Calculated members in an MDX query represent values that do not exist directly in a data source but are calculated from cube metadata for members. You can define a calculated member and then use it like any existing member from an Analysis Services cube. For example, you can drag and drop the calculated member onto the data or filter pane in Design Mode or onto the query pane in Query mode for inclusion in an MDX query. For more information, see "Calculated Member Builder Dialog Box (Analysis Services - Multidimensional Data)" in SQL Server Books Online.

There are two ways to add a calculated member through the user interface: using the Add Calculated Member button on the toolbar or using the context menu from the calculated member pane.

To add a calculated member from the toolbar button

  1. In the Analysis Services MDX Query Designer, on the query designer toolbar, click the Add Calculated Member (Add calculated member) button.

  2. In Name, type a name for the calculated member.

  3. For Parent Hierarchy, select the hierarchy under which to place this member.

  4. For Parent Member, select which member to use for the parent of the calculated member.

    Note

    If Parent Hierarchy is MEASURES, Parent Member is disabled.

  5. In Expression, type the MDX expression to use to calculate the member. You can drag objects from the Metadata and Functions lists to populate the expression with those objects.

  6. Click OK.

To add a calculated member from the calculated member pane

  1. In the Analysis Services MDX Query Designer, below the metadata pane, right-click anywhere in the calculated member pane.

  2. Click New Calculated Member.

  3. In Name, type a name for the calculated member.

  4. For Parent Hierarchy, select the hierarchy under which to place this member.

  5. For Parent Member, select which member to use for the parent of the calculated member.

    Note

    If Parent Hierarchy is MEASURES, Parent Member is disabled.

  6. In Expression, type the MDX expression to use to calculate the member. You can drag objects from the Metadata and Functions lists to populate the expression with those objects.

  7. Click OK.