Skip to main content
Analysis Services 2005 Aggregation Design Strategy
Entry Date: Rate:
RSS Description:
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.

How to create effective aggregations based on logging MDX queries.