3.1.4.2.2.1.3.10.1 Columns

  • Article

The MDSCHEMA_PROPERTIES 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.<239>

CUBE_NAME

xsd:string

Yes

The name of the cube.

DIMENSION_UNIQUE_NAME

xsd:string

Yes

The unique name of the dimension.

HIERARCHY_UNIQUE_NAME

xsd:string

Yes

The unique name of the hierarchy.

LEVEL_UNIQUE_NAME

xsd:string

Yes

The unique name of the level to which the property belongs.

MEMBER_UNIQUE_NAME

xsd:string

Yes

The unique name of the member to which the property belongs.

PROPERTY_TYPE

xsd:short

Yes

A bitmask that specifies the type of the property, as follows:

  • 1 - Identifies a property of a member.

  • 2 - Identifies a property of a cell.

  • 4 - Identifies an internal property.

  • 8 - Identifies a property which contains a binary large object (BLOB).

PROPERTY_NAME

xsd:string

Yes

The name of the property.

PROPERTY_CAPTION

xsd:string

A label or caption associated with the property.<240>

DATA_TYPE

xsd:unsignedShort

This enumeration is the same as LEVEL_DBTYPE for MDSCHEMA_LEVELS. (See 3.1.4.2.2.1.3.8)

CHARACTER_MAXIMUM_LENGTH

xsd:unsignedInt

The maximum possible length of the property, if it is a Character or Binary type.

Zero indicates there is no defined maximum length.

Returns NULL for all other data types.

CHARACTER_OCTET_LENGTH

xsd:unsignedInt

The maximum possible length (in bytes) of the property, if it is a Character or Binary type.

Zero indicates there is no defined maximum length.

Returns NULL for all other data types.

NUMERIC_PRECISION

xsd:unsignedShort

The maximum precision of the property if the measure object's data type is Numeric, Decimal or DateTime. NULL for all other property types.

NUMERIC_SCALE

xsd:short

The number of digits to the right of the decimal point if the measure object's type indicator is Numeric, Decimal or DateTime. Otherwise, this value is NULL.<241>

DESCRIPTION

xsd:string

A description of the property.

PROPERTY_CONTENT_TYPE

xsd:short

The content type of the property.

Built-in values are values listed as follows. This enumeration is extensible and additional values can be added by users.

  • 0x00 - Regular

  • 0x01 - Id

  • 0x02 - Relation to parent

  • 0x03 - Rollup operator

  • 0x11 - Organization title

  • 0x21 - Caption

  • 0x22 - Caption short

  • 0x23 - Caption description

  • 0x24 - Caption abbreviation

  • 0x31 - Web URL

  • 0x32 - Web HTML

  • 0x33 - Web XML or XSL

  • 0x34 - Web mail alias

  • 0x41 - Address

  • 0x42 - Address street

  • 0x43 - Address house

  • 0x44 - Address city

  • 0x45 - Address state or province

  • 0x46 - Address zip

  • 0x47 - Address quarter

  • 0x48 - Address country

  • 0x49 - Address building

  • 0x4A - Address room

  • 0x4B - Address floor

  • 0x4C - Address fax

  • 0x4D - Address phone

  • 0x61 - Geography centroid x

  • 0x62 - Geography centroid y

  • 0x63 - Geography centroid z

  • 0x64 - Geography boundary top

  • 0x65 - Geography boundary left

  • 0x66 - Geography boundary bottom

  • 0x67 - Geography boundary right

  • 0x68 - Geography boundary front

  • 0x69 - Geography boundary rear

  • 0x6A - Geography boundary polygon

  • 0x71 - Physical size

  • 0x72 - Physical color

  • 0x73 - Physical weight

  • 0x74 - Physical height

  • 0x75 - Physical width

  • 0x76 - Physical depth

  • 0x77 - Physical volume

  • 0x78 - Physical density

  • 0x82 - Person full name

  • 0x83 - Person first name

  • 0x84 - Person last name

  • 0x85 - Person middle name

  • 0x86 - Person demographic

  • 0x87 - Person contact

  • 0x91 - Quantity range low

  • 0x92 - Quantity range high

  • 0xA1 - Formatting color

  • 0xA2 - Formatting order

  • 0xA3 - Formatting font

  • 0xA4 - Formatting font effects

  • 0xA5 - Formatting font size

  • 0xA6 - Formatting sub total

  • 0xB1 - Date

  • 0xB2 - Date start

  • 0xB3 - Date ended

  • 0xB4 - Date canceled

  • 0xB5 - Date modified

  • 0xB6 - Date duration

  • 0xC1 - Version

SQL_COLUMN_NAME

xsd:string

The column name of the property used in SQL queries.

LANGUAGE

xsd:unsignedShort

The language expressed as an LCID. Valid only for property translations.

PROPERTY_ORIGIN

xsd:unsignedShort

Yes

A bitmask that specifies the type of hierarchy to which the property applies, as follows:

  • 1 - Indicates the property is on a user defined hierarchy.

  • 2 - Indicates the property is on an attribute hierarchy.

  • 4 - Indicates the property is on a key attribute hierarchy.

  • 8 - Indicates the property is on an attribute hierarchy that is not enabled.

PROPERTY_ATTRIBUTE_HIERARCHY_NAME

xsd:string

The name of the attribute hierarchy that is sourcing this property.

PROPERTY_CARDINALITY

xsd:string

The cardinality of the property. Possible values include the following strings:

  • "ONE"

  • "MANY"

MIME_TYPE

xsd:string

The MIME type (if this property is of type Binary).

PROPERTY_IS_VISIBLE

xsd:boolean

When true, indicates that the property is visible; otherwise false.

This schema rowset is not sorted.

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="DIMENSION_UNIQUE_NAME" name="DIMENSION_UNIQUE_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="HIERARCHY_UNIQUE_NAME" name="HIERARCHY_UNIQUE_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="LEVEL_UNIQUE_NAME" name="LEVEL_UNIQUE_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="MEMBER_UNIQUE_NAME" name="MEMBER_UNIQUE_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="PROPERTY_TYPE" name="PROPERTY_TYPE" 
                            type="xsd:short" minOccurs="0" />
           <xsd:element sql:field="PROPERTY_NAME" name="PROPERTY_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="PROPERTY_CAPTION" name="PROPERTY_CAPTION" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="DATA_TYPE" name="DATA_TYPE" 
                            type="xsd:unsignedShort" minOccurs="0" />
           <xsd:element sql:field="CHARACTER_MAXIMUM_LENGTH" name="CHARACTER_MAXIMUM_LENGTH"     
                            type="xsd:unsignedInt" minOccurs="0" />
           <xsd:element sql:field="CHARACTER_OCTET_LENGTH" name="CHARACTER_OCTET_LENGTH"  
                            type="xsd:unsignedInt" minOccurs="0" />
           <xsd:element sql:field="NUMERIC_PRECISION" name="NUMERIC_PRECISION" 
                            type="xsd:unsignedShort" minOccurs="0" />
           <xsd:element sql:field="NUMERIC_SCALE" name="NUMERIC_SCALE" 
                            type="xsd:short" minOccurs="0" />
           <xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="PROPERTY_CONTENT_TYPE" name="PROPERTY_CONTENT_TYPE" 
                            type="xsd:short" minOccurs="0" />
           <xsd:element sql:field="SQL_COLUMN_NAME" name="SQL_COLUMN_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="LANGUAGE" name="LANGUAGE" 
                            type="xsd:unsignedShort" minOccurs="0" />
           <xsd:element sql:field="PROPERTY_ORIGIN" name="PROPERTY_ORIGIN" 
                            type="xsd:unsignedShort" minOccurs="0" />
           <xsd:element sql:field="PROPERTY_ATTRIBUTE_HIERARCHY_NAME" 
                            name="PROPERTY_ATTRIBUTE_HIERARCHY_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="PROPERTY_CARDINALITY" name="PROPERTY_CARDINALITY" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="MIME_TYPE" name="MIME_TYPE" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="PROPERTY_IS_VISIBLE" name="PROPERTY_IS_VISIBLE" 
                            type="xsd:boolean" minOccurs="0" />
         </xsd:sequence>
       </xsd:complexType>