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
If you have not already done so, open the MDX Query Editor to the MDX Step-by-Step database.
If required, ...