3.1.4.2.2.1.3.13.1 Columns
The MDSCHEMA_SETS rowset contains the following columns.
|
Name |
Type |
Restriction |
Description |
|---|---|---|---|
|
CATALOG_NAME |
xsd:string |
Yes |
The name of the database. |
|
SCHEMA_NAME |
xsd:string |
Yes |
The name of the schema.<248> |
|
CUBE_NAME |
xsd:string |
Yes |
The name of the cube. |
|
SET_NAME |
xsd:string |
Yes |
The name of the set, as specified in the CREATE SET statement. |
|
SCOPE |
xsd:int |
Yes |
The scope of the set. The set can be a session-defined set or a global-defined set. This column can have one of the following values:
|
|
DESCRIPTION |
xsd:string |
|
A description of the set. |
|
EXPRESSION |
xsd:string |
|
The expression for the set. |
|
DIMENSIONS |
xsd:string |
|
A comma-delimited list of hierarchies included in the set. |
|
SET_CAPTION |
xsd:string |
|
A caption associated with the set. |
|
SET_DISPLAY_FOLDER |
xsd:string |
|
The display folder. |
|
SET_EVALUATION_CONTEXT |
xsd:int |
|
The context for the set. The set can be static or dynamic. This column can have one of the following values:
|
The rowset is sorted on CATALOG_NAME and CUBE_NAME.
The response has the following definition.
-
<xsd:element name="root"> <xsd:complexType> <xsd:sequence minOccurs="0" maxOccurs="unbounded"> <xsd:element name="row" type="row" /> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:complexType name="row"> <xsd:sequence> <xsd:element sql:field="CATALOG_NAME" name="CATALOG_NAME" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="SCHEMA_NAME" name="SCHEMA_NAME" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="CUBE_NAME" name="CUBE_NAME" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="SET_NAME" name="SET_NAME" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="SCOPE" name="SCOPE" type="xsd:int" minOccurs="0" /> <xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="EXPRESSION" name="EXPRESSION" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="DIMENSIONS" name="DIMENSIONS" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="SET_CAPTION" name="SET_CAPTION" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="SET_DISPLAY_FOLDER" name="SET_DISPLAY_FOLDER" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="SET_EVALUATION_CONTEXT" name="SET_EVALUATION_CONTEXT" type="xsd:int" minOccurs="0" /> </xsd:sequence> </xsd:complexType>