This documentation is archived and is not being maintained.

How to: Add a Calculated Member for a SAP NetWeaver BI MDX Query (Report Designer)

New: 14 April 2006

Calculated members in an MDX query represent values that do not exist directly in a SAP NetWeaver Business Intelligence 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 InfoCube or Query cube. For example, you can drag the calculated member onto the Data pane or a Query pane for inclusion in an MDX query.

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

  1. In Data view, in the SAP NetWeaver Business Intelligence 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 the member to be the parent of the calculated member.

    ms365169.note(en-US,SQL.90).gifNote:
    If Parent Hierarchy is KEY FIGURES, Parent Member is disabled.

  5. In Expression, type the 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.

  1. In Data view, in the SAP NetWeaver Business Intelligence 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 the member to be the parent of the calculated member.

    ms365169.note(en-US,SQL.90).gifNote:
    If Parent Hierarchy is KEY FIGURES, Parent Member is disabled.

  6. In Expression, type the 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.

Show: