Exposed Schema

Some of the OLE DB schema rowsets that are common to tabular data providers are interpreted differently when they are used with Microsoft® SQL Server™ 2000 Analysis Services. The interpretation that Analysis Services ascribes to each one is listed in the following table.

Rowset	Meaning in Analysis Services
CATALOGS	The list of catalogs (databases).
TABLES	The list of cubes. For SQL queries, each cube can function as a table.
COLUMNS	The 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.