Mapping Overview

A dataset is a complex entity. In relational terms, it is not convenient to represent a dataset as a two-dimensional table. Instead, it is represented as a set of multiple tables. There is a total of n+1 tables, where n is the number of axes in the dataset.

Consider an MDX statement of the form:

SELECT
   <axis specification> ON COLUMNS,
   <axis specification> ON ROWS
FROM <cube specification>
WHERE <slicer specification>

This statement is mapped to a set of SQL statements, which results in the following three tables: