How to: Create Member Groups

If an attribute has a large number of members, you can choose to group those members into buckets, reducing the number of members that users see when they browse the data in a hierarchy. You can also determine the number of buckets in which the members are groups and set a naming scheme for the buckets. For more information, see Grouping Attribute Members (Discretization).

You group members by setting the DiscretizationMethod property, which is accessed through the Properties window in Business Intelligence Development Studio.

When you create member groups, your changes are not available to users until you process the dimension. For more information, see Processing in Analysis Services.

To create member groups

  1. Open the dimension that you want to work with. The Dimension Structure tab opens by default.

  2. In Attributes, right-click the attribute whose members you want to group, and then click Properties.

  3. From the drop-down list next to DiscretizationMethod, select a method by which to group the members. For more information about DiscretizationMethod settings, see Grouping Attribute Members (Discretization).

See Also

Other Resources

Working with Database Dimension Basics How-to Topics
Automatically Grouping Attribute Members

Help and Information

Getting SQL Server 2005 Assistance