How to create a named set in a regular cube

To create a named set in a regular cube

1. In the Analysis Manager tree pane, under the database in which you want to create the named set, expand the Cubes folder.
   
   
2. Right-click the cube in which you want to create the named set, and then click Edit.
   
   
3. In Cube Editor, on the Insert menu, click Named Set.
   
   
4. In Named Set Builder, in the Set name box, type a name for the named set.
   
   
5. 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 ({}).

6. (Optional.) To register additional function libraries, click Register.
   
   
7. To close Named Set Builder, click OK.
   
   
8. To save the named set, in Cube Editor, on the File menu, click Save.

See Also

Creating Named Sets in Regular Cubes