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 ...

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

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