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 3. Common Calculations and Selections in MDX

Having had a brief introduction to queries, and to how calculations are formed, you are ready to look at how a variety of common calculations and selections are expressed in MDX. Some will be trivial and amount to using one of the many MDX functions. Some will be less simple but composed of just a few of the functions working together. This chapter is an introduction to a vocabulary of the most commonly used functions. Here is where you start to actually see examples of composing MDX as small assemblies of "moving parts." Chapter 7 will put the vocabulary and techniques introduced here to more use.

This chapter will provide a fairly broad, technical introduction. Although we can make suggestions for how the techniques can be applied to different domains, such as analyzing trends in manufacturing quality, insurance claims, analyzing cross-sectional drug prescription behavior, or consumer purchasing patterns, most applications of MDX for analysis and reporting draw on the same collection of techniques tied together in only slightly differing ways. The rest of this book attempts to provide examples in terms of the Waremart 2005 application available on this book's web site. However, in order to provide techniques for domains not covered in that database, this chapter will provide illustrative MDX that does not correspond to any sample database.

Different application domains may use different terminology for the same technique. For ...

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