Retrieving Values from Cells
You can create many useful MDX expressions that look only at the names of members, but expressions get even more interesting when you refer to values from cells in the cube. To see how MDX refers to values in cells, consider first how an Excel formula refers to values in other cells.
Retrieve a Value by Specifying a Single Dimension
Imagine that you are creating a spreadsheet that calculates the margin (that is, sales minus cost) for three product categories. Traditionally, spreadsheet formulas have used addresses to refer to cells.
The formula in cell D3 uses the address B3 to refer to dairy sales. The address ...