How to: Add a Calculated Member for a SAP NetWeaver BI MDX Query
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.
To add a calculated member using a toolbar button
In the SAP Netweaver BI Query Designer, on the query designer toolbar, click the Add Calculated Member (
.gif "Add calculated member")
) button.In Name, type a name for the calculated member.
For Parent Hierarchy, select the hierarchy under which to place this member.
For Parent Member, select which member to use for the parent of the calculated member.
Note
If Parent Hierarchy is KEY FIGURES, Parent Member is disabled.
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.
Click OK.
To add a calculated member using the calculated member pane
In the SAP Netweaver BI Query Designer, below the metadata pane, right-click anywhere in the calculated member pane.
Click New Calculated Member.
In Name, type a name for the calculated member.
For Parent Hierarchy, select the hierarchy under which to place this member.
For Parent Member, select which member to use for the parent of the calculated member.
Note
If Parent Hierarchy is KEY FIGURES, Parent Member is disabled.
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.
Click OK.