Chapter 6. Building Complex Sets

After completing this chapter, you will be able to:

  • Assemble an ordered set

  • Apply criteria to control set membership

  • Apply set logic and advanced set building techniques

Part I introduced you to the fundamental concepts of tuples, sets, and expressions. Part II, you build upon this foundation as you explore some of the more frequently used MDX functions.

Part II marks the book’s transition from theory to application. Although the theoretical concepts explored in Part I are now largely relegated to the background, you are strongly encouraged to continually apply those concepts to the examples presented in these chapters to deepen your understanding of the MDX language.

In this chapter, you explore the assembly of complex ...

Get Microsoft® SQL Server® 2008 MDX Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.