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
|
Contains information about the available cubes in a schema or the catalog, if the provider does not support schemas. |
MDSCHEMA_DIMENSIONS |
5 | CATALOG_NAME
|
Contains information about the dimensions in a given cube. It has one row for each dimension. |
MDSCHEMA_FUNCTIONS |
4 | LIBRARY_NAME
|
Contains information on the functions that are available to client applications connected to the database. |
MDSCHEMA_HIERARCHIES |
6 | CATALOG_NAME
|
Contains information about the hierarchies available in a dimension. |
MDSCHEMA_LEVELS |
7 | CATALOG_NAME
LEVEL_UNIQUE_NAME |
Contains information about the levels available in a dimension. |
MDSCHEMA_MEASURES |
5 | CATALOG_NAME
|
Contains information about the available measures. |
MDSCHEMA_PROPERTIES |
9 | CATALOG_NAME
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
|
Contains information about the available members. |
MDSCHEMA_SETS |
4 | CATALOG_NAME
|
Contains information on any sets that are currently defined within a database, including session-scoped sets. |