SSAS Articles 
Performance Tuning Influencing Aggregation Candidates (by Elizabeth Vitt)
Performance Tuning Influencing Aggregation Candidates (by Elizabeth Vitt)
| Influencing Aggregation Candidates (by Elizabeth Vitt) |
| Written by Elizabeth Vitt |
| Saturday, 19 May 2007 18:24 |
|
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... |
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
