Creating and Maintaining Calculated Members in Virtual Cubes

Analysis Services

Analysis Services

Creating and Maintaining Calculated Members in Virtual Cubes

You can import calculated members into virtual cubes from their component cubes and you can also create new calculated members directly in virtual cubes. With Calculated Member Builder you can create and edit calculated members in virtual cubes. In a virtual cube, you can import calculated members from the component cubes of that virtual cube so that you do not have to re-create the calculated members. After import, you can edit the calculated member in the virtual cube.

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

Note  Virtual Cube Editor is used for maintaining calculated members in virtual cubes only. To maintain calculated members in regular cubes, use Cube Editor to access Calculated Member Builder.

The topics in the following table describe the three basic procedures for maintaining calculated members in virtual cubes.

Topic Description
Importing a Calculated Member into a Virtual Cube Contains information about importing one or more calculated members from the component cubes of a virtual cube to the virtual cube.
Editing a Calculated Member in a Virtual Cube Describes how to update the calculated members of a virtual cube.
Creating a Calculated Member in a Virtual Cube Describes how to add new calculated members to a virtual cube.

See Also

Calculated Members

Creating Calculated Members

Virtual Cubes

Virtual Cube Editor