O'Reilly logo

Microsoft® SQL Server® 2008 MDX Step by Step by C Ryan Clay Bryan C Smith and Hitachi Consulting

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required