Export (0) Print
Expand All

Exposed Schema

SQL Server 2000

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.

© 2015 Microsoft