Aggregation Design Life-Cycle: Introduction
When it comes to maximizing Analysis Services query performance, nothing beats a solid dimensional data model with appropriately configured attribute relationships and a good measure group partitioning strategy. This of course assumes the instance is already properly configured with adequate hardware resources. If you've got all that in place and you're still looking to eek out that last bit of performance, then its time to focus on a good aggregation strategy.
Read more...Tags: management, aggregation