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

need to create aggregations at the All level because most of the
queries will not hit the aggregation.
5. Leave the setting for the customer dimension as Default, and click
the Attributes tab in the cube editor as shown in Figure 13-39 . BIDS
will now show all the cube dimensions with their cube dimension at-
tributes. Click the country dimension to view its attributes.
Figure 13-39
6. Click any of the cube dimension attributes. If you look at the proper-
ties window you will see the property AggregationUsage as shown in
Figure 13-39 . Similar to AllMemberAggregationUsage, the Aggrega-
tionUsage property also has four possible values. They are Full,
None, Unrestricted, and Default. These properties once again in-
struct the aggregation design algorithm to appropriately include or
exclude a dimension attribute while designing aggregations. The
meaning of the values are as follows:
◦ Full. Always include this attribute in any of the aggregation
designs being considered while designing aggregations.
◦ None. Never include this attribute in any of the aggregation
designs being considered while designing aggregations.