Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

OLE DB for OLAP Schema Rowsets

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

NoteNote

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.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.