Udostępnij za pośrednictwem


OLE DB for OLAP Schema Rowsets

The Microsoft XML for Analysis (XMLA) provider supports the following OLE DB for OLAP schema rowsets.

Note

To check whether a particular data source provider supports a rowset, use the DISCOVER_ENUMERATIONS rowset with the Discover method.

You can also find detailed information about these rowsets by searching for the topic, "OLAP Schema Rowsets," in the MSDN Library at this Microsoft Web site.

In This Section

Schema Rowset1 Description

DISCOVER_INSTANCES Rowset

Describes the instances on the server.

DISCOVER_KEYWORDS Rowset (OLE DB for OLAP)

Enumerates a list of words reserved by the provider.

MDSCHEMA_ACTIONS Rowset

Describes the actions that may be available to the client application.

MDSCHEMA_CUBES Rowset

Describes the structure of cubes within a database.

MDSCHEMA_DIMENSIONS Rowset

Describes the shared and private dimensions within a database.

MDSCHEMA_FUNCTIONS Rowset

Describes the functions that are available to client applications connected to the database.

MDSCHEMA_HIERARCHIES Rowset

Describes each hierarchy that is contained in a particular dimension.

MDSCHEMA_INPUT_DATASOURCES Rowset

Describes the data sources defined within the database.

MDSCHEMA_KPIS Rowset

Describes the key performance indicators (KPIs) within a database.

MDSCHEMA_LEVELS Rowset

Describes each level within a particular hierarchy.

MDSCHEMA_MEASUREGROUP_DIMENSIONS

Enumerates the dimensions of measure groups.

MDSCHEMA_MEASUREGROUPS Rowset

Describes the measure groups within a database.

MDSCHEMA_MEASURES Rowset

Describes each measure within in a cube.

MDSCHEMA_MEMBERS Rowset

Describes the members within a database.

MDSCHEMA_PROPERTIES Rowset

Describes the properties of members within in a database.

MDSCHEMA_SETS Rowset

Describes any sets that are currently defined in a database, including session-scoped sets.

1 All the schema rowsets listed here are supported by the MSOLAP data source provider for the Microsoft XMLA provider.

See Also

Reference

DISCOVER_ENUMERATORS Rowset
Schema Rowsets

Help and Information

Getting SQL Server 2005 Assistance