OLE DB for OLAP Schema Rowsets
Applies To: SQL Server 2016 Preview
The Microsoft XML for Analysis (XMLA) provider supports the following OLE DB for OLAP schema rowsets.
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.
|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 Rowset||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.