Designing Effective Aggregations in AS2005 (by Chris Webb)
Aggregations are, as we all know, the key to getting the best performance out of your cube. In AS2K it was usually enough to run the Aggregation Design Wizard to get a reasonable aggregation design; in my experience with AS2005 it's much harder to achieve good results - a lot of people run the wizard and find that performance is still poor. So what I thought I'd do is detail the process I go through when I'm designing aggregations...
Tags: performance, aggregation