Returning Values Based on Specified Dimensions
Let's begin by extending our use of MDX to retrieve values from a multidimensional data source. We'll explore a couple of approaches to the retrieval of values within this section:
We'll create a calculated measure that refers, by its definition, to the current member.
We'll use a calculated member to refer to the current measure.
Initially, we'll apply both approaches while specifying a single dimension in the expression, and then we'll broaden our options by specifying multiple dimensions to return values.