Preparing to Create MDX Queries

The purpose of an MDX query is to extract values from an OLAP cube into a report. As explained in Chapter 1, “A Data Analysis Foundation,” a cube has dimensions (up to 64, if you count Measures as a dimension). A report does not have dimensions; it has axes (typically, a row axis, a column axis, and a filter axis). An axis can include labels from more than one dimension. A cube contains all possible values for all members of all levels of all dimensions. A report contains only selected values from selected levels of selected dimensions. An MDX query statement consists of the instructions for extracting a report from a cube.

Use a PivotTable List to Understand MDX Terms

An MDX query statement uses several new ...

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.