Do not build more than 500 aggregations for a partition
This rule analyzes partitions to determine whether there are too many aggregations.
Best Practices Recommendations
For best performance, you should typically avoid building too many aggregations. If you build too many aggregations, it can adversely affect performance by increasing the search space during queries and increasing the work necessary during processing. As a rule, do not build more than 500 aggregations per partition.
For More Information
For more information about how to design aggregations, see Designing Partition Storage and Aggregations in SQL Server Books Online.
For performance issues related to aggregations, partitions, and multiple aggregation designs, see the section, "Aggregation considerations for multiple partitions," in the SQL Server 2005 Analysis Services Performance Guide.