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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
