SSAS Articles 
Performance Tuning Partitions and Aggregations
Performance Tuning Partitions and Aggregations
| Partitions and Aggregations |
| Written by Chris Webb |
| Monday, 03 December 2007 15:44 |
|
Something that's easy to forget when creating an aggregation design is the impact that partitioning can have on it. Aggregations are only created on a per-partition basis - you can't aggregate across partitions - so that means, for example, when you're partitioning by Month then there's little point building aggregations at granularities higher than Month; after all, if you only have one Month of data in your partition and you aggregate that data to the Month, Quarter or Year levels then the figures for each aggregation will be identical! |
Latest Author Articles
- Reporting Services-generate MDX, Subselects and Formula Caching
- Calculated members are better than assignments to real members (at least sometimes)
- Using AS Data Mining to Add Forecast Values to a Cube
- Displaying totals at the bottom
- Generating large numbers of partitions using Excel
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
- SSAS Tutorial: SQL Server 2005 Analysis Services Tutorial by Accelebrate
