Importing a Named Set into a Virtual Cube

To import a named set into a virtual cube, use Virtual Cube Editor and the Import Named Sets dialog box.

To import a named set into a virtual cube

Analysis Manager

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

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

When you import a named set, you will see an error message if the named set's syntax is incorrect or if its expression includes a measure, dimension, or other object that is not in the virtual cube. (The named set's expression is displayed beside Value in the properties pane of Virtual Cube Editor.) The named set 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 the Virtual Cube Wizard. To start the Virtual Cube Wizard from within Virtual Cube Editor, on the Edit menu, click Structure... (Wizard).

  -or-

• Edit the named set with the error and remove from its expression the measure, dimension, or object that is not in the virtual cube. For more information, see Editing a Named Set in a Virtual Cube.