Skip to Content
Microsoft® SQL Server® 2008 MDX Step by Step
book

Microsoft® SQL Server® 2008 MDX Step by Step

by C Ryan Clay Bryan C Smith and Hitachi Consulting
February 2009
Beginner to intermediate content levelBeginner to intermediate
400 pages
9h 59m
English
Microsoft Press
Content preview from Microsoft® SQL Server® 2008 MDX Step by Step

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® SQL Server® 2008 Analysis Services Step by Step

Microsoft® SQL Server® 2008 Analysis Services Step by Step

Scott Cameron
Professional Microsoft® SQL Server® Analysis Services 2008 with MDX

Professional Microsoft® SQL Server® Analysis Services 2008 with MDX

Sivakumar Harinath, Matt Carroll, Sethu Meenakshisundaram, Robert Zare, Denny Guang-Yeu Lee

Publisher Resources

ISBN: 9780735626188Purchase book