Supported schema rowsets

This table describes the different schema rowsets that are supported according to the XMLA Specification 1.1:

GUID Number of restrictions Restriction columns Description
MDSCHEMA_CUBES 3 CATALOG_NAME

SCHEMA_NAME

CUBE_NAME

Contains information about the available cubes in a schema or the catalog, if the provider does not support schemas.
MDSCHEMA_DIMENSIONS 5 CATALOG_NAME

SCHEMA_NAME

CUBE_NAME

DIMENSION_NAME

DIMENSION_UNIQUE_NAME

Contains information about the dimensions in a given cube. It has one row for each dimension.
MDSCHEMA_FUNCTIONS 4 LIBRARY_NAME

INTERFACE_NAME

FUNCTION_NAME

RESTRICTIONS

Contains information on the functions that are available to client applications connected to the database.
MDSCHEMA_HIERARCHIES 6 CATALOG_NAME

SCHEMA_NAME

CUBE_NAME

DIMENSION_UNIQUE_NAME

HIERARCHY_NAME

HIERARCHY_UNIQUE_NAME

Contains information about the hierarchies available in a dimension.
MDSCHEMA_LEVELS 7 CATALOG_NAME

SCHEMA_NAME

CUBE_NAME

DIMENSION_UNIQUE_NAME

HIERARCHY_UNIQUE_NAME

LEVEL_NAME

LEVEL_UNIQUE_NAME
Contains information about the levels available in a dimension.
MDSCHEMA_MEASURES 5 CATALOG_NAME

SCHEMA_NAME

CUBE_NAME

MEASURE_NAME

MEASURE_UNIQUE_NAME

Contains information about the available measures.
MDSCHEMA_PROPERTIES 9 CATALOG_NAME

TENANT_NAME

SCHEMA_NAME

CUBE_NAME

DIMENSION_UNIQUE_NAME

HIERARCHY_UNIQUE_NAME

LEVEL_UNIQUE_NAME

MEMBER_UNIQUE_NAME

PROPERTY_TYPE

PROPERTY_NAME
Contains information about the available properties for each level of the dimension, if each level defines a class of members. The properties of all members in this class are the same. This schema table also contains all available properties for cells in a dataset.

SCHEMA_NAME is obsolete.

MDSCHEMA_MEMBERS 12 CATALOG_NAME

SCHEMA_NAME

CUBE_NAME

DIMENSION_UNIQUE_NAME

HIERARCHY_UNIQUE_NAME

LEVEL_UNIQUE_NAME

LEVEL_NUMBER

MEMBER_NAME

MEMBER_UNIQUE_NAME

MEMBER_CAPTION

MEMBER_TYPE

Tree operator

Contains information about the available members.
MDSCHEMA_SETS 4 CATALOG_NAME

SCHEMA_NAME

CUBE_NAME

SET_NAME

SCOPE

Contains information on any sets that are currently defined within a database, including session-scoped sets.