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