O'Reilly logo

Microsoft® SQL Server® 2008 MDX Step by Step by C Ryan Clay Bryan C Smith and Hitachi Consulting

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 7. Performing Aggregation

After completing this chapter, you will be able to:

  • Perform basic aggregations using MDX functions

  • Employ appropriate strategies for calculating aggregate values

Analysis Services records and returns measures as aggregate values. The singular aggregate value returned for a given measure may represent hundreds, thousands, or even millions of individually recorded fact table entries. An aggregation function assigned to the measure at design time determines how these many fact table values are combined to form the singular value returned.

You can perform additional aggregation on top of these aggregate values through the use of the MDX aggregation functions. These functions provide insight into the magnitude and distribution ...

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