Influencing Aggregation Candidates (by Elizabeth Vitt)
Mention aggregations to any OLAP geek and you will likely hear that aggregations are the cornerstones of OLAP databases.
In the new attribute paradigm of Analysis Services 2005, designing effective aggregations can be a somewhat challenging task. In fact there are many components that go into building an effective aggregation design.
In this entry, I am going to highlight the design components that determine which attributes are considered for aggregation...Tags: performance, aggregation