Analysis Services
How to edit a named set in a virtual cube
To edit a named set in a virtual cube
- In the Analysis Manager tree pane, right-click the virtual cube, and then click Edit.
- In the Virtual Cube Editor tree pane, right-click the named set, and then click Edit.
- 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 ({}).
- Drag items from the Data and Functions boxes.
- (Optional.) To register additional function libraries, click Register.
- To close Named Set Builder, click OK.
- To save the named set, in Virtual Cube Editor, on the File menu, click Save.