Exposed Schema

Analysis Services Programming

previous page next page
Analysis Services Programming

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.
previous page start next page