Calculated Member Builder
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.
Select the dimension in which to create the calculated 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.
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.
Enter a name for the calculated member (for example, Average Sale.)
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.
Click to validate the syntax in the Value expression box.
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.
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.
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.
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.