Report Portal

Analysis Services 2005 Aggregation Design Strategy

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.

Read more...

Tags: design, performance, aggregation

 

2007-2015 VidasSoft Systems Inc.