How to edit a named set in a virtual cube

Analysis Services

Analysis Services

How to edit a named set in a virtual cube

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