O'Reilly logo

SQL Server MVP Deep Dives by Greg Low, Paul Randal, Kimberly Tripp, Adam Machanic, Kalen Delaney, Paul Nielsen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 55. To aggregate or not to aggregate—is there really a question?

Erin Welker

Aggregations have long been the key to gaining the best query performance from Analysis Services, yet they are commonly misunderstood. What, exactly, are aggregations? What is the best approach for designing aggregations? What tools are available to assist you with this task? What changes have occurred in the various releases of Analysis Services that affect your approach to aggregation design?

I hope to answer all of these questions and more in this chapter. Read on.

What are aggregations?

You can think of aggregations as precalculated answers to OLAP queries. Let’s take the scenario of a query on a cube with three dimensions—Product, Customer, and Sales ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required