Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
How to edit a named set in a virtual cube

How to edit a named set in a virtual cube

SQL Server 2000

To edit a named set in a virtual cube

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

  2. In the Virtual Cube Editor tree pane, right-click the named set, and then click Edit.

  3. In Named Set Builder, in the Set expression box, construct an expression for the named set. 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.

      Note  If you create the set expression by explicitly naming the members in the set, enclose the list of members in a pair of braces ({}).

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

  5. To close Named Set Builder, click OK.

  6. To save the named set, in Virtual Cube Editor, on the File menu, click Save.

See Also

Editing a Named Set in a Virtual Cube

© 2015 Microsoft