Calculated Member Builder

The Calculated Member Builder enables you to add calculated members to a cube or virtual cube.


Note For information about the standard Microsoft® SQL Server OLAP Services functions, see Function List.


This dialog box appears for a virtual cube whenever you do one of the following in the Calculated Member Manager:

This dialog box appears for a regular cube whenever you do one of the following in the Cube editor:

Options

Parent dimension

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

Parent member

If you select a parent dimension other than Measures that has more than one level, the Change button is 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.

Value expression

Build the calculated member’s expression using the Data box and the Functions box. The Data box contains the cube’s dimensions, measures, and existing calculated members. The Functions box contains the standard OLAP Services function library plus any additional libraries that have been registered. For information about the OLAP Services functions, see Function List. For information about an individual OLAP Services function, select it in the Functions box, and then press F1.


Note The Data and Functions boxes provides a 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. In the Value expression box, place the cursor where you want to insert the function.
  2. Select the desired function in the Functions box.
  3. Click Insert (located above the calculator pad).

The function syntax appears in the Value expression box. Replace any arguments with the appropriate expressions.

Example

In the sample Warehouse and Sales virtual cube, to manually enter a calculated member that finds the average profit margin by store, defined as 1 - Store Cost/Store Sales, follow these steps:

  1. In the Value expression box, type “1-”.
  2. In the Data box, expand Measures and MeasuresLevel to display the individual measures.
  3. Select Store Cost, and then click Insert.
  4. In the Value expression box, place the cursor at the end of the phrase that was just entered, and then type “/”.
  5. In the Data box, select Store Sales.
  6. Click Insert.

    The following expression appears in the Value expression box:

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

  7. In the Member name box, type “Average Store Margin”, and then click OK.

(c) 1999 Microsoft Corporation. All Rights Reserved.