Avoid setting the 'ProcessingGroup' dimension property to 'ByTable'
This rule analyzes database dimensions to determine whether the ProcessingGroup property is set to ByTable.
Best Practices Recommendations
In most cases, the default setting of ByAttribute will result in faster processing performance and better memory utilization. The ByTable setting is designed to boost performance in a limited set of scenarios by reducing the load on the relational database. However, the ByTable setting uses a lot of Analysis Services resources and can result in scalability issues at very large volumes.
For More Information
For more information, see the SQL Server 2005 Analysis Services Performance Guide.