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:
Expand the drop-down list and select the dimension in which this calculated member is to be created.
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.
The name of this calculated member (for example, “Average Sale”).
Register an external function type library (*.olb, *.tlb, *.dll). The new library will appear in the Functions box.
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
The function syntax appears in the Value expression box. Replace any arguments with the appropriate expressions.
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:
The following expression appears in the Value expression box:
1-[Measures].[Store Cost]/[Measures].[Store Sales]