Creating Member Groups
A dimension level can contain member groups, which are system-generated parents of collections of consecutive dimension members. End users see no difference between member groups and ordinary members.
Member groups can provide an intermediate level for drilldown between a level with few members and one with numerous members. They can also be used to satisfy the requirement of having no more than 64,000 members under a parent member.
You can choose to create member groups automatically in regular dimensions while you are creating them with the Dimension Wizard. This option is available only for member groups immediately above the lowest level of the dimension. To select this option, in the Specify storage mode and create member groups step of the wizard, select Create member groups automatically.
To create member groups in an existing dimension, create a copy of the level that contains the numerous or excess members immediately above the original. Then create member groups in the new level, which you can hide if you don't want end users to see the new level.
Important Members of the level used to create member groups must have unique names. Set the Member Names Unique property to True for the level in Dimension Editor or Cube Editor before you create member groups.
Member groups rely on the Order By property of the level that contains their children. This property specifies the sort order of displayed members. Within this sort order, a member group's children are consecutive.
To create member groups in an existing dimension, use Dimension Editor or Cube Editor.
To create member groups