Calculated Member Builder

Enables you to add calculated members to a cube.

Note For information about the standard OLAP functions, see Function List.

This dialog box appears whenever you do one of the following from the Cube editor:

• On the Insert menu, click Calculated Member.
• Click the Insert Calculated Member button on the toolbar.
• In the tree view, right-click either the Calculated Members folder or a calculated member, and then click New Calculated Member.
• In the tree view, right-click a calculated member, and then click Edit.

Parent dimension

Expand the drop-down list and select the dimension from which this calculated member is to be derived.

Parent member

If you select a parent dimension other than Measures, the Change button will be enabled. Click Change, and then select a parent member.

Member name

The name of this calculated member. For example, “Average Sale.”

Register

Register an external function type library (*.olb, *.tlb, *.dll). The new library will appear in the Functions box for your use.

Value expression

Build the calculated member’s expression using the data members in the Data box and the functions in the Functions box. The Data box contains the cube’s dimensions, measures and existing calculated members. The Functions box contains the standard OLAP function library plus any additional libraries that have been registered by previous users. For information about the standard OLAP functions, see Function List.

Note Using the Data and Functions boxes provides a powerful and convenient means for building valid value expressions. You can also type an expression directly into the Value expression box.

To add a function to the value expression

1. Place the pointer where you want the function inserted in the Value expression box.
2. Select the desired function in the Functions box.
3. Click Insert (located above the calculator pad).

This action places a copy of the function syntax in the Value expression box. Replace any arguments with the appropriate expressions.

Example

To manually enter a calculated member that finds the average profit margin by store, which is defined as 1 - Store Cost/Store Sales, enter the following in the Value expression box:

• Type “1-”.
• In the Data box, expand the Measures | MeasuresLevel member to display the individual measure columns.
• Select Store Cost.
• Click Insert.
• In the Value expression box, place the pointer at the end of the phrase that was just entered, and then type a “/”.
• In the Data list box, select Store Sales.
• Click Insert.

  The following expression will appear in the Value expression box:

  1-[Measures].[Store Cost]/[Measures].[Store Sales]

• In the Member Name box, type “Average Store Margin”.
• Click OK.