OLE DB Programmer's Reference |
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 following 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:
For further information about MDX statements, see the following topics in this section:
1998-2001 Microsoft Corporation. All rights reserved.