Importing a Calculated Member into a Virtual Cube

Analysis Services

Analysis Services

Importing a Calculated Member into a Virtual Cube

When you import a calculated member, you will see an error message if the syntax of the calculated member is incorrect or its value expression includes a measure, dimension, or other object that is not in the virtual cube. (The value expression is displayed beside Value in the properties pane of Virtual Cube Editor.) The calculated member is not included in the virtual cube data displayed to end users as long as the error exists. To correct the error, you can:

  • Add the missing measure, dimension, or object to the virtual cube and process it. To add a measure or dimension, use Virtual Cube Wizard. To start Virtual Cube Wizard from within Virtual Cube Editor, on the Edit menu, click Structure (Wizard).

    -or-

  • Edit the calculated member with the error and remove from its value expression the measure, dimension, or object that is not in the virtual cube. For more information, see Editing a Calculated Member in a Virtual Cube.

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.

You can import calculated members only from cubes that are in the same database as the edited virtual cube.

To import a calculated member into a virtual cube, use Virtual Cube Editor and the Import Calculated Members dialog box.

To import a calculated member into a virtual cube