Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Calculated Member Builder
Collapse the table of content
Expand the table of content

Calculated Member Builder

SQL Server 2000

Calculated Member Builder

Use this dialog box to add a calculated member to a cube or virtual cube.

This dialog box appears for a cube or a virtual cube when you do one of the following in Cube Editor or in Virtual Cube Editor:

  • On the Insert menu, click Calculated Member.

  • In the tree pane, right-click the Calculated Members folder or a calculated member, and then click New Calculated Member.

  • In the tree pane, right-click a calculated member, and then click Edit.

  • On the toolbar, click Insert Calculated Member.
Options

Parent dimension

Select the dimension in which to create the calculated member.

Parent member

Enter an expression for the parent member of the calculated member, or click Change to select a parent member. The parent member determines the location of the calculated member in the dimension structure. This option is enabled if you select a parent dimension (other than the Measures dimension) that has more than one level.

  • Change

    Click to display the Select the Parent Member dialog box. This option is enabled if you select a parent dimension other than Measures that has more than one level.

Member name

Enter a name for the calculated member (for example, Average Sale.)

Value expression

Build or enter the expression that determines the values of the calculated member. To add a function to the Value expression box, place the cursor where you want to insert the function, select a function in the Functions box, and either double-click the function or click Insert. The function syntax appears in the Value expression box. Replace arguments and their delimiters (« and ») with the appropriate values.

You can also type an expression directly into the Value expression box. You must use this method if you want to add functions from libraries other than the Microsoft® SQL Server™ 2000 Analysis Services Multidimensional Expressions (MDX) function library.

Check

Click to validate the syntax in the Value expression box.

Data

Select the cube's dimensions, measures, and existing calculated members to build the expression in the Value expression box. To add objects, you can double-click the selected object, select the object and then click Insert, or drag the selected object to the Value expression box.

Functions

Select a function from the list to build the expression in the Value expression box. To add functions, you can double-click the selected object, select the object and then click Insert, or drag the selected object to the Value expression box. The list includes the Analysis Services MDX function library and any additional function libraries you have registered. For MDX, a short description of the function and an example of the syntax are displayed below the Functions and Data boxes. For more information about the functions, see MDX Function List.

Insert

Click to add the item selected in the Data box or Functions box to the value expression.

Number and arithmetic operator buttons

Click to add numbers and operators to the value expression.

Register

Click to display the Register Function Libraries dialog box, where you can register an external function type library (*.olb, *.tlb, *.dll). The new library appears in the Functions box. For more information, see Register Function Libraries Dialog Box.

See Also

Registered Function Libraries

Select the Parent Member Dialog Box

Show:
© 2015 Microsoft