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

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:

  • 1 - Global

  • 2 – Session

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:

  • 1 - STATIC

  • 2 – DYNAMIC

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>
           
  • Last updated on