Skip to Main Content
MDX Solutions: With Microsoft® SQL Server™ Analysis Services 2005 and Hyperion® Essbase, Second Edition
book

MDX Solutions: With Microsoft® SQL Server™ Analysis Services 2005 and Hyperion® Essbase, Second Edition

by George Spofford, Sivakumar Harinath, Christopher Webb, Dylan Hai Huang, Francesco Civardi
March 2006
Intermediate to advanced content levelIntermediate to advanced
744 pages
16h 7m
English
Wiley
Content preview from MDX Solutions: With Microsoft® SQL Server™ Analysis Services 2005 and Hyperion® Essbase, Second Edition

Chapter 12. The Many Ways to Calculate in Microsoft Analysis Services

Microsoft Analysis Services 2000 provided many different ways of calculating a cell, and not much guidance on which one to choose for your application. Microsoft Analysis Services 2005 has added a new way of MDX programming, via MDX scripting. In this chapter, we describe the mechanics and interactions of the "traditional ways of calculating," while the description of MDX scripting is left to another chapter. An important difference between the two approaches is that, while Scripts can only be defined at the server, some of the techniques described here can be defined and/or modified within user sessions or even per query. We will provide a few simple tips to keep in mind when applying them.

The ways to calculate a cell are

  1. Intrinsic aggregation for a measure

  2. Rollup by custom unary rollup operator

  3. Custom member formula

  4. Calculated member

  5. Cell calculation

We have described calculated members in some detail already because they are part of standard MDX and useful in almost every application. We haven't discussed the intrinsic aggregation for a measure very much, but then again it's simple enough almost to take for granted. (It's also something that you don't have any control over in MDX, except when creating a local cube using Microsoft's CREATE CUBE statement.) We'll discuss the custom rollups in some depth in this chapter. The custom member or custom rollup formulas are MDX expressions, whereas the unary rollup operators ...

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

Professional SQL Server™ Analysis Services 2005 with MDX

Professional SQL Server™ Analysis Services 2005 with MDX

Sivakumar Harinath, Stephen R. Quinn
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
Microsoft® SQL Server™ 2008 Analysis Services Unleashed

Microsoft® SQL Server™ 2008 Analysis Services Unleashed

Irina Gorbach, Alexander Berger, Edward Melomed

Publisher Resources

ISBN: 9780471748083Purchase book