Business Intelligence and Big Data with the Microsoft Stack, For Database Administrators

SQTH05 Add It Up: Analysis Services Aggregations


9:30AM - 10:45AM

Level: Intermediate to Advanced

Craig Utley

Craig Utley



Are you looking to maximize the performance of your Analysis Services queries? This session explains what aggregations are and how they work. You'll learn how to create aggregations, tune the aggregations based on actual usage, and design custom aggregations when necessary. You'll discover the benefits and pitfalls of flexible aggregations, when to use rigid aggregations, and the meaning of lazy aggregation processing. You'll dive into queries to see if aggregations are being used and learn when aggregations aren't useful. If you thought aggregation design began and ended with the aggregation wizard, you owe it to yourself (and your cubes) to attend this session.

You will learn:

  • How SSAS creates and uses aggregations
  • To monitor queries to ensure aggregations are being used
  • How to develop a framework to create meaningful aggregations and improve them over time