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