How to create member groups

To create member groups

1. Access the dimension that will contain the member groups:
   • If the dimension is shared, in the Analysis Manager tree pane, right-click the dimension, and then click Edit.
     
     
   • If the dimension is private, in the Analysis Manager tree pane, right-click the cube that contains the dimension, and then click Edit. In the Cube Editor tree pane, expand the dimension to reveal its levels.
2. Create a copy of the level that contains the members that will be the children of the member groups. Create it immediately above the original. To do this, follow these steps:
   1. In the editor tree pane, select the level to be copied.
      
      
   2. If the properties pane is not expanded, expand it by clicking Properties beneath the tree pane.
      
      
   3. In the properties pane, click the Basic tab.
      
      
   4. Record the value of the Member Key Column property.
      
      
   5. On the Insert menu, click Level.
      
      
   6. In the Select Column dialog box, select the column recorded in Step d, and then click OK.
      
      
   7. Select the new level.
      
      
   8. Drag the new level to a position immediately above the original level.
      
      
   9. In the properties pane, ensure that all of the new level's properties except Name have the same values as the original level.
3. In the editor tree pane, select the level in which you want to create member groups. (Select the new level from Step 2, not the original level.)
   
   
4. In the properties pane, click the Advanced tab.
   
   
5. For the Grouping property, select Automatic.
   
   
6. If you want to hide from end users the level that contains the member groups, follow these steps:
   1. In the editor tree pane, select the level that contains the member groups.
      
      
   2. In the properties pane, click the Advanced tab.
      
      
   3. Change the value of the Visible property to False.
7. In the editor, on the File menu, click Save.

See Also

Creating Member Groups