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. |