Home > Articles > Data > SQL Server

  • Print
  • + Share This
Like this article? We recommend

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.

  • + Share This
  • 🔖 Save To Your Account