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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.