Share via

3.1.4.2.2.1.3.17.1 Columns

  • Article

The MDSCHEMA_MEASUREGROUP_DIMENSIONS rowset contains the following columns.

Name

Type

Restriction

Description

CATALOG_NAME

xsd:string

Yes

The name of the catalog.

SCHEMA_NAME

xsd:string

Yes

The name of the schema.<253>

CUBE_NAME

xsd:string

Yes

The name of the cube.

MEASUREGROUP_NAME

xsd:string

Yes

The name of the measure group.

MEASUREGROUP_CARDINALITY

xsd:string

The number of instances a measure in the measure group can have for a single dimension member.

Possible values include:

  • ONE

  • MANY

DIMENSION_UNIQUE_NAME

xsd:string

Yes

The unique name for the dimension.

DIMENSION_CARDINALITY

xsd:string

The number of instances a dimension member can have for a single instance of a measure group measure.

Possible values include:

  • ONE

  • MANY

DIMENSION_IS_VISIBLE

xsd:boolean

When true, indicates that hierarchies in the dimension are visible; otherwise false.

DIMENSION_IS_FACT_DIMENSION

xsd:boolean

When true, indicates that the dimension is a fact dimension; otherwise false.

DIMENSION_PATH

nested rowset

A list of dimensions for the reference dimension. The column name of the nested row is "MeasureGroupDimension". For information on nested rowsets, see section 2.2.4.1.3.1.1.

DIMENSION_GRANULARITY

xsd:string

The unique name of the attribute hierarchy that represents the granularity of the dimension.

The rowset supports sorting on CATALOG_NAME, CUBE_NAME, MEASUREGROUP_NAME, and DIMENSION_UNIQUE_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="MEASUREGROUP_NAME" name="MEASUREGROUP_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="MEASUREGROUP_CARDINALITY" name="MEASUREGROUP_CARDINALITY" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="DIMENSION_UNIQUE_NAME" name="DIMENSION_UNIQUE_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="DIMENSION_CARDINALITY" name="DIMENSION_CARDINALITY" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="DIMENSION_IS_VISIBLE" name="DIMENSION_IS_VISIBLE" 
                            type="xsd:boolean" minOccurs="0" />
           <xsd:element sql:field="DIMENSION_IS_FACT_DIMENSION" 
                             name="DIMENSION_IS_FACT_DIMENSION" 
                             type="xsd:boolean" minOccurs="0" />
           <xsd:element sql:field="DIMENSION_PATH" name="DIMENSION_PATH" 
                            minOccurs="0" maxOccurs="unbounded">
             <xsd:complexType>
               <xsd:sequence>
                 <xsd:element sql:field="MeasureGroupDimension" name="MeasureGroupDimension" 
                                  type="xsd:string" minOccurs="0" />
               </xsd:sequence>
             </xsd:complexType>
           </xsd:element>
           <xsd:element sql:field="DIMENSION_GRANULARITY" name="DIMENSION_GRANULARITY" 
                             type="xsd:string" minOccurs="0" />
         </xsd:sequence>
       </xsd:complexType>