MSAS - Creating and Maintaining Calculated Members in Virtual Cubes

Calculated members can be imported into virtual cubes from their component cubes. New calculated members also can be created directly into virtual cubes. The Calculated member Builder can be used to build the members or calculated members created in component cubes can be imported and then the same can be edited.

The virtual cube editor is used to maintain the calculated members in virtual cubes. The Virtual cube Editor provides a single click access to Calculated Member Builder and the Import Calculated Members dialog box, which can be used to import calculated members into the virtual cube.

Creating a Calculated Member in a Virtual Cube

In the Analysis Manager tree pane, right-click the virtual cube, and then click Edit.

In Virtual Cube Editor, on the Insert menu, click Calculated Member.

In Calculated Member Builder, in the Parent dimension box, select the dimension that will include the calculated member. Select Store.

In the Parent member box, specify the member that will include the calculated member.

In the Member name box, type a name for the calculated member as Store Profit.

In the Value expression box, construct an expression to produce the values of the calculated member.

[Measures].[Store sales]-[Measures].[Store Cost]

Use any combination of the following methods to add to the expression:

Drag items from the Data and Functions boxes.

Click an item in the Data or Functions box, and then click Insert.

Click the arithmetic operator and number buttons.

Type.

(Optional.) To register additional function libraries, click Register.

To close Calculated Member Builder, click OK.

To save the calculated member, in Virtual Cube Editor, on the File menu, click Save.

Importing a Calculated Member into a Virtual Cube

While importing a calculated member into a virtual cube, it is important that the syntax of the Calculated member is validated. Syntax errors can occur due to incorrectness of the expression or that the value expression includes a measure, dimension or other objects which are not available in the virtual cube. The calculated member will not be displayed to end users so long as the error is not rectified. The syntax errors can be corrected by invoking the Virtual cube Wizard from within the Virtual cube Editor, or by clicking Structure(Wizard) on the Edit menu of the Virtual Cube Editor. The calculated member can also be edited in the Calculated Member builder and re-imported.