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 7. Advanced MDX Application Topics

In the last four chapters, you have looked at basic calculations and selections in MDX, and expanded the vocabulary of functions and operators with which you can compose expressions. In this chapter, we are going to put together the pieces in many more ways, working through some more advanced concepts and techniques. Many of these come from assistance the author has given to other MDX users over the last seven years, so if some seem esoteric at first, remember that MDX has many different applications!

The same problem may be solved in multiple ways in MDX. The point of this chapter is both to give you a reference to solutions to many common and/or advanced requirements, and to increase your prowess in "thinking in MDX." So, alternatives will be presented when there are interesting differences in approach. Since there are important differences in the capabilities of the three product versions that this book refers to, we will also explore product-specific differences in ways of constructing the expressions that achieve the goal where relevant. As you read through this chapter, you will start to see recurring patterns in the way the various moving parts of MDX are assembled.

The expressions and queries in this chapter are oriented more toward the composition of whole analytical queries, and the principles that go into constructing them are useful for constructing all manner of sophisticated analyses, even if the particular examples presented ...

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