SSAS Articles 
Performance Tuning Analysis Services 2005 Aggregation Design Strategy
Performance Tuning Analysis Services 2005 Aggregation Design Strategy
| Analysis Services 2005 Aggregation Design Strategy |
| Written by Eric Jacobsen |
| Thursday, 13 December 2007 05:55 |
| Designing effective aggregations are a well known way to improve query performance (for the sake of AS processing time). As you may have noticed in Tip #2 of the of the Analysis Services Query Performance Top 10 Best Practices whitepaper, the best way to define effective aggregations is to use the Aggregation Manager sample application. Here we discuss one of the strategies for adding effective aggregations using this tool. |
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Using AS Data Mining to Add Forecast Values to a Cube
- 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)
