Exposed Schema

Microsoft® SQL Server™ OLAP Services is both a tabular data provider, as well as a multidimensional data provider. Several OLE DB schema rowsets commonly used by consumers of tabular data are listed below.

CATALOGS rowset

List of catalogs (databases).

TABLES rowset

List of cubes. For SQL queries, each cube can function as a table.

COLUMNS rowset

List of levels and measures for each cube. Column names are of the form dimension_name:level_name and dimension_name:measure_name. For SQL queries, each level and each measure can function as an SQL column.

For more information, see the OLE DB documentation.