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 5. Working with Expressions

After completing this chapter, you will be able to:

  • Assemble expressions employing constants, tuples, members, and sets

  • Explain the concept of expression context

  • Successfully employ context to build dynamic expressions

Although Analysis Services is highly efficient at storing and retrieving values, the ability to calculate new values—values difficult to derive from the relational data warehouse—is where Analysis Services really shines. Expressions provide this capability.

The subject of expressions is very broad in nature. In this chapter, you focus on a particular type of expression known as a calculated member. Calculated members are frequently employed for calculating new values in Analysis Services cubes and ...

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