3.1.4.2.2.1.3.8.1 Columns

  • Article

The MDSCHEMA_LEVELS 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.<231>

CUBE_NAME

xsd:string

Yes

The name of the cube.

DIMENSION_UNIQUE_NAME

xsd:string

Yes

The unique name of the dimension.<232>

HIERARCHY_UNIQUE_NAME

xsd:string

Yes

The unique name of the hierarchy.

LEVEL_NAME

xsd:string

Yes

The name of the level.

LEVEL_UNIQUE_NAME

xsd:string

Yes

The unique name of the level.

LEVEL_GUID

uuid

The GUID of the level.

LEVEL_CAPTION

xsd:string

The caption of the hierarchy.<233>

LEVEL_NUMBER

xsd:unsignedInt

The level number in the hierarchy. Top level is zero (0).

LEVEL_CARDINALITY

xsd:unsignedInt

The number of members in the level.

LEVEL_TYPE

xsd:int

The type of the level from a list of possible values.

  • Account 0x1014

  • All 0x0001

  • Bill of Material Resource 0x1012

  • Calculated 0x0002

  • Channel 0x1061

  • Company 0x1042

  • Currency Destination 0x1052

  • Currency Source 0x1051

  • Customer 0x1021

  • Customer Group 0x1022

  • Customer Household 0x1023

  • Geography City 0x2006

  • Geography Continent 0x2001

  • Geography country 0x2003

  • Geography County 0x2005

  • Geography Point 0x2008

  • Postal Code 0x2007

  • Geography Region 0x2002

  • Geography StateOrProvince 0x2004

  • Organization Unit 0x1011

  • Person 0x1041

  • Product 0x1031

  • Product Group 0x1032

  • Promotion 0x1071

  • Quantitative 0x1013

  • Regular 0x0000

  • Representative 0x1062

  • Reserved1 0x0008

  • Scenario 0x1015

  • Time 0x0004

  • Time Days 0x0204

  • Time Half Years 0x0024

  • Time Quarters 0x0044

  • Time Seconds 0x0804

  • Time Undefined 0x1004

  • Time Weeks 0x0104

  • Time Years 0x0014

  • Utility 0x1016

DESCRIPTION

xsd:string

A description of the level.

CUSTOM_ROLLUP_SETTINGS

xsd:int

A bitmask that specifies the custom rollup options:

  • 0x01 - Indicates that a custom rollup expression exists for this level.

  • 0x02 - Indicates that members of this level have custom rollup expressions.

  • 0x04 - Indicates that there is a skipped level associated with members of this level.

  • 0x08 - Indicates that members of this level have custom member properties.

  • 0x10 - Indicates that members on this level have unary operators.

LEVEL_UNIQUE_SETTINGS

xsd:int

A bitmask that specifies which columns contain unique values, if the level only has members with unique names or keys:

  • 0x00000001 - Member key columns establish uniqueness.

  • 0x00000002 - Member name columns establish uniqueness.

LEVEL_IS_VISIBLE

xsd:boolean

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

LEVEL_ORDERING_PROPERTY

xsd:string

The name of the attribute on which the level is sorted.

LEVEL_DBTYPE

xsd:int

The type of the member key column that is used for the level attribute. It MUST be null if concatenated keys are used as the member key column.

Type values are described in the following list:

  • 0 – (DBTYPE_EMPTY) Indicates that no value was specified.

  • 2 – (DBTYPE_I2) Indicates a two-byte signed integer.

  • 3 – (DBTYPE_I4) Indicates a four-byte signed integer.

  • 4 – (DBTYPE_R4) Indicates a single-precision floating-point value.

  • 5 – (DBTYPE_R8) Indicates a double-precision floating-point value.

  • 6 – (DBTYPE_CY) Indicates a currency value. Currency is a fixed-point number with four digits to the right of the decimal point and is stored in an eight-byte signed integer scaled by 10,000.

  • 7 – (DBTYPE_DATE) Indicates a date value. Date values are stored as Double, the whole part of which is the number of days since December 30, 1899, and the fractional part of which is the fraction of a day.

  • 8 – (DBTYPE_BSTR) A pointer to a BSTR, which is a null-terminated character string in which the string length is stored with the string.

  • 9 – (DBTYPE_IDISPATCH) Indicates a pointer to an IDispatch interface on an OLE object.

  • 10 – (DBTYPE_ERROR) Indicates a 32-bit error code.

  • 11 – (DBTYPE_BOOL) Indicates a Boolean value.

  • 12 – (DBTYPE_VARIANT) Indicates an Automation variant.

  • 13 – (DBTYPE_IUNKNOWN) Indicates a pointer to an IUnknown interface on an OLE object.

  • 14 – (DBTYPE_DECIMAL) Indicates an exact numeric value with a fixed precision and scale. The scale is between 0 and 28.

  • 16 – (DBTYPE_I1) Indicates a one-byte signed integer.

  • 17 – (DBTYPE_UI1) Indicates a one-byte unsigned integer.

  • 18 – (DBTYPE_UI2) Indicates a two-byte unsigned integer.

  • 19 – (DBTYPE_UI4) Indicates a four-byte unsigned integer.

  • 20 – (DBTYPE_I8) Indicates an eight-byte signed integer.

  • 21 – (DBTYPE_UI8) Indicates an eight-byte unsigned integer.

  • 72 – (DBTYPE_GUID) Indicates a GUID.

  • 128 – (DBTYPE_BYTES) Indicates a binary value.

  • 129 – (DBTYPE_STR) Indicates a string value.

  • 130 – (DBTYPE_WSTR) Indicates a null-terminated Unicode character string.

  • 131 – (DBTYPE_NUMERIC) Indicates an exact numeric value with a fixed precision and scale. The scale is between 0 and 38.

  • 132 – (DBTYPE_UDT) Indicates a user-defined variable.

  • 133 – (DBTYPE_DBDATE) Indicates a date value (yyyymmdd).

  • 134 – (DBTYPE_DBTIME) Indicates a time value (hhmmss).

  • 135 – (DBTYPE_DBTIMESTAMP) Indicates a date-time stamp (yyyymmddhhmmss plus a fraction in billionths).

  • 136 - (DBTYPE_HCHAPTER) Indicates a four-byte chapter value used to identify rows in a child rowset.

LEVEL_MASTER_UNIQUE_NAME

xsd:string

The unique name of the master level.

LEVEL_NAME_SQL_COLUMN_NAME

xsd:string

The SQL column name for the level name.

LEVEL_KEY_SQL_COLUMN_NAME

xsd:string

The SQL column name for the level key.

LEVEL_UNIQUE_NAME_SQL_COLUMN_NAME

xsd:string

The SQL column name for the level unique name.

LEVEL_ATTRIBUTE_HIERARCHY_NAME

xsd:string

The name of the attribute hierarchy that provides the source of the level.

LEVEL_KEY_CARDINALITY

xsd:unsignedShort

The number of columns in the level key.

LEVEL_ORIGIN

xsd:unsignedShort

Yes

A bitmask that defines how the level was sourced:

  • 0x0001 - Identifies levels in a user defined hierarchy.

  • 0x0002 - Identifies levels in an attribute hierarchy.

  • 0x0004 - Identifies levels in a key attribute hierarchy.

  • 0x0008 - Identifies levels in attribute hierarchies that are not enabled.

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_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_NAME" name="LEVEL_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="LEVEL_GUID" name="LEVEL_GUID" 
                            type="uuid" minOccurs="0" />
           <xsd:element sql:field="LEVEL_CAPTION" name="LEVEL_CAPTION" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="LEVEL_NUMBER" name="LEVEL_NUMBER" 
                            type="xsd:unsignedInt" minOccurs="0" />
           <xsd:element sql:field="LEVEL_CARDINALITY" name="LEVEL_CARDINALITY" 
                            type="xsd:unsignedInt" minOccurs="0" />
           <xsd:element sql:field="LEVEL_TYPE" name="LEVEL_TYPE" 
                            type="xsd:int" minOccurs="0" />
           <xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="CUSTOM_ROLLUP_SETTINGS" name="CUSTOM_ROLLUP_SETTINGS" 
                            type="xsd:int" minOccurs="0" />
           <xsd:element sql:field="LEVEL_UNIQUE_SETTINGS" name="LEVEL_UNIQUE_SETTINGS" 
                            type="xsd:int" minOccurs="0" />
           <xsd:element sql:field="LEVEL_IS_VISIBLE" name="LEVEL_IS_VISIBLE" 
                            type="xsd:boolean" minOccurs="0" />
           <xsd:element sql:field="LEVEL_ORDERING_PROPERTY" name="LEVEL_ORDERING_PROPERTY" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="LEVEL_DBTYPE" name="LEVEL_DBTYPE" 
                            type="xsd:int" minOccurs="0" />
           <xsd:element sql:field="LEVEL_MASTER_UNIQUE_NAME" name="LEVEL_MASTER_UNIQUE_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="LEVEL_NAME_SQL_COLUMN_NAME" 
                            name="LEVEL_NAME_SQL_COLUMN_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="LEVEL_KEY_SQL_COLUMN_NAME" 
                            name="LEVEL_KEY_SQL_COLUMN_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="LEVEL_UNIQUE_NAME_SQL_COLUMN_NAME" 
                            name="LEVEL_UNIQUE_NAME_SQL_COLUMN_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="LEVEL_ATTRIBUTE_HIERARCHY_NAME" 
                            name="LEVEL_ATTRIBUTE_HIERARCHY_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="LEVEL_KEY_CARDINALITY" name="LEVEL_KEY_CARDINALITY" 
                            type="xsd:unsignedShort" minOccurs="0" />
           <xsd:element sql:field="LEVEL_ORIGIN" name="LEVEL_ORIGIN" 
                            type="xsd:unsignedShort" minOccurs="0" />
         </xsd:sequence>
       </xsd:complexType>