Importing a Calculated Member into a Virtual Cube

To import a calculated member into a virtual cube, use the Calculated Member Manager and the Import Calculated Members dialog box.

To import a calculated member into a virtual cube

  1. In the OLAP Manager tree view, right-click the virtual cube, and then click Manage Calculated Members.
  2. In the Calculated Member Manager, on the File menu, click Import Calculated Member.
  3. In the Import Calculated Members dialog box, select the check box beside the calculated member, and then click OK. (To select all the calculated members in a cube, select the check box beside the cube.)
  4. In the Calculated Member Manager, on the File menu, click Save.

You can import only calculated members that are in the virtual cube’s component cubes.

If you import a calculated member with the same name as a calculated member already in the virtual cube, the imported calculated member is given a new name consisting of its old name and a numeric suffix.

When you import a calculated member, you will see an error message if the calculated member’s value expression includes a measure, dimension, or calculated member that is not in the virtual cube. (The value expression is displayed beside Value in the Calculated Member Manager’s Properties pane.) A calculated member with this type of error is represented in the Calculated Member Manager’s List pane by an icon with a red circle and white X. The calculated member is not included in the cube data displayed to end users as long as the error exists. To correct the error, you can:

(c) 1999 Microsoft Corporation. All Rights Reserved.