Skip to Content
Microsoft® SQL Server® 2008 MDX Step by Step
book

Microsoft® SQL Server® 2008 MDX Step by Step

by C Ryan Clay Bryan C Smith and Hitachi Consulting
February 2009
Beginner to intermediate content levelBeginner to intermediate
400 pages
9h 59m
English
Microsoft Press
Content preview from Microsoft® SQL Server® 2008 MDX Step by Step

Chapter 4. Working with Sets

After completing this chapter, you will be able to:

  • Assemble sets using basic techniques

  • Employ sets to retrieve multiple cells through a single query

  • Explain the basic components of the SELECT statement

In the last chapter, you learned how a tuple is used to locate a cell within a cube. In this chapter, you build upon that concept, using collections of tuples, known as sets, to retrieve multiple cells. Along the way, you expand your understanding of the SELECT statement and gain exposure to some basic set-building MDX functions.

Set Basics

In Analysis Services, a set is a collection of tuples. Within a set, individual tuples are separated from each other by commas, and the set itself is enclosed in braces ({ }). The following ...

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

Microsoft® SQL Server® 2008 Analysis Services Step by Step

Microsoft® SQL Server® 2008 Analysis Services Step by Step

Scott Cameron
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

Publisher Resources

ISBN: 9780735626188Purchase book