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

Building Dynamic Expressions

In Analysis Services, a tuple identifies a cell and that cell provides access to a value. It’s a small logical leap, but you could say that a tuple simply represents a value. Doing so allows you to incorporate tuples into expressions as placeholders for values. These tuple placeholders differ from the constant values you employed in the last exercise in that their value is variable, depending on the context within which the expression is being resolved. In this way, incorporating tuples allows you to build dynamic expressions. The following exercise demonstrates these concepts.

Construct a dynamic calculated member

  1. If you have not already done so, open the MDX Query Editor to the MDX Step-by-Step database.

  2. If required, ...

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