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 ...

Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.