Share via

3.1.4.2.2.1.3.6.1 Columns

  • Article

The MDSCHEMA_DIMENSIONS 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.<219>

CUBE_NAME

xsd:string

Yes

The name of the cube.

DIMENSION_NAME

xsd:string

Yes

The name of the dimension.

DIMENSION_UNIQUE_NAME

xsd:string

Yes

The unique name of the dimension.

DIMENSION_GUID

uuid

The GUID of the dimension.

DIMENSION_CAPTION

xsd:string

The caption of the dimension.

DIMENSION_ORDINAL

xsd:unsignedInt

The position of the dimension within the cube.

DIMENSION_TYPE

xsd:short

The type of the dimension. Valid values are:

  • 0 - UNKNOWN

  • 1 - TIME

  • 2 - MEASURE

  • 3 - OTHER

  • 5 - QUANTITATIVE

  • 6- ACCOUNTS

  • 7 - CUSTOMERS

  • 8- PRODUCTS

  • 9 - SCENARIO

  • 10- UTILITY

  • 11 - CURRENCY

  • 12 - RATES

  • 13 - CHANNEL

  • 14 - PROMOTION

  • 15 - ORGANIZATION

  • 16 - BILL OF MATERIALS

  • 17 – GEOGRAPHY

DIMENSION_CARDINALITY

xsd:unsignedInt

The number of members in the key attribute.

DEFAULT_HIERARCHY

xsd:string

The default hierarchy of the dimension.

DESCRIPTION

xsd:string

A description of the dimension.

IS_VIRTUAL

xsd:boolean

When true, indicates that the dimension is virtual; otherwise false.<220>

IS_READWRITE

xsd:boolean

When true, indicates that the dimension is write-enabled; otherwise false.

DIMENSION_UNIQUE_SETTINGS

xsd:int

A bitmask that specifies which columns contain unique values:

  • 0x00000001 - Member key columns establish uniqueness.

  • 0x00000002 - Member name columns establish uniqueness.

DIMENSION_MASTER_NAME

xsd:string

The name of the master dimension.

DIMENSION_IS_VISIBLE

xsd:boolean

When true, indicates that the dimension is visible in a client application; otherwise false.

The rowset is sorted on CATALOG_NAME, CUBE_NAME, and DIMENSION_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:simpleType name="uuid">
         <xsd:restriction base="xsd:string">
           <xsd:pattern value="[0-9a-zA-Z]{8}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{4}-
                               [0-9a-zA-Z]{4}-[0-9a-zA-Z]{12}" />
         </xsd:restriction>
       </xsd:simpleType>
       <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="DIMENSION_NAME" name="DIMENSION_NAME" 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_GUID" name="DIMENSION_GUID" type="uuid" 
                        minOccurs="0" />
           <xsd:element sql:field="DIMENSION_CAPTION" name="DIMENSION_CAPTION" 
                        type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="DIMENSION_ORDINAL" name="DIMENSION_ORDINAL" 
                        type="xsd:unsignedInt" minOccurs="0" />
           <xsd:element sql:field="DIMENSION_TYPE" name="DIMENSION_TYPE" type="xsd:short" 
                        minOccurs="0" />
           <xsd:element sql:field="DIMENSION_CARDINALITY" name="DIMENSION_CARDINALITY" 
                        type="xsd:unsignedInt" minOccurs="0" />
           <xsd:element sql:field="DEFAULT_HIERARCHY" name="DEFAULT_HIERARCHY" 
                        type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="IS_VIRTUAL" name="IS_VIRTUAL" type="xsd:boolean" 
                        minOccurs="0" />
           <xsd:element sql:field="IS_READWRITE" name="IS_READWRITE" type="xsd:boolean" 
                        minOccurs="0" />
           <xsd:element sql:field="DIMENSION_UNIQUE_SETTINGS" name="DIMENSION_UNIQUE_SETTINGS" 
                        type="xsd:int" minOccurs="0" />
           <xsd:element sql:field="DIMENSION_MASTER_NAME" name="DIMENSION_MASTER_NAME" 
                        type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="DIMENSION_IS_VISIBLE" name="DIMENSION_IS_VISIBLE" 
                        type="xsd:boolean" minOccurs="0" />
         </xsd:sequence>
       </xsd:complexType>