Performance Optimization - Professional SQL Server Analysis Services 2005 with MDX - page 693

Figure 13-38
4. You will see the property AllMemberAggregationUsage. This property
enables you to either include or exclude the "All Member" of the di-
mension while creating aggregations. Based on the value set for this
property, Aggregation Design Wizard will consider this dimension
while performing the design task. There are four choices for the
AllMemberAggregationUsage property.
◦ Full. Always include the All member while creating aggrega-
tions.
◦ None. Never include the All member while creating aggreg-
ations.
◦ Unrestricted. Let Analysis Services consider the dimension
during aggregation design, and it can choose to build or not
build aggregation for all members of the dimension.
◦ Default. Same as unrestricted.
If most of your users query All member of this dimension, we recom-
mend that you change the AllMemberAggregationUsage property to
Full. This ensures that aggregations include the All member and that
your user queries hit and benefit from the aggregations. If most of
your users query this dimension at the detail level, we recommend
you set it to None to avoid aggregation at the All level. There is no