3.1.4.2.2.1.3.11.1 Columns

The MDSCHEMA_MEMBERS 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.<254>

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.

LEVEL_NUMBER

xsd:unsignedInt

Yes

The distance of the member from the root of the hierarchy. The root level is zero (0).

MEMBER_ORDINAL

xsd:unsignedInt

The ordinal of the member in its level.

MEMBER_NAME

xsd:string

Yes

The name of the member.

MEMBER_UNIQUE_NAME

xsd:string

Yes

The unique name of the member.

MEMBER_TYPE

xsd:int

Yes

The type of the member.<255>

  • 1 - Is a regular member.

  • 2 - Is the All member.

  • 3 - Is a measure.

  • 4 - Is a formula.

  • 0 - Is of unknown type.

MEMBER_GUID

uuid

The GUID of the member.

MEMBER_CAPTION

xsd:string

Yes

The caption of the member.

CHILDREN_CARDINALITY

xsd:unsignedInt

The number of children that the member has. This can be an estimate.

PARENT_LEVEL

xsd:unsignedInt

The distance of the member's parent from the root level of the hierarchy. The root level is zero (0).

PARENT_UNIQUE_NAME

xsd:string

The unique name of the member's parent. NULL is returned for any members at the root level.

PARENT_COUNT

xsd:unsignedInt

The number of parents that this member has.

DESCRIPTION

xsd:string

The description of the member.

EXPRESSION

xsd:string

The expression for calculations, if the member is of type 4 (Formula).

MEMBER_KEY

xsd:string

The value of the member's key column. Returns NULL if the member has a composite key.

IS_PLACEHOLDERMEMBER

xsd:boolean

When true, indicates that a member is a placeholder member for an empty position in a dimension hierarchy; otherwise false.

It is valid only if the MDX Compatibility property has been set to 1.

IS_DATAMEMBER

xsd:boolean

When true, indicates that the member is a data member; otherwise false.

SCOPE

xsd:int

The scope of the member. The member can be a session-calculated member or a global-calculated member. The column returns NULL for non-calculated members.

This column can have one of the following values:

  • 1 – Global

  • 2 – Session

Additional columns can be returned in this schema rowset for custom member properties.

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_UNIQUE_NAME" name="LEVEL_UNIQUE_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="LEVEL_NUMBER" name="LEVEL_NUMBER" 
                            type="xsd:unsignedInt" minOccurs="0" />
           <xsd:element sql:field="MEMBER_ORDINAL" name="MEMBER_ORDINAL" 
                            type="xsd:unsignedInt" minOccurs="0" />
           <xsd:element sql:field="MEMBER_NAME" name="MEMBER_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="MEMBER_TYPE" name="MEMBER_TYPE" 
                            type="xsd:int" minOccurs="0" />
           <xsd:element sql:field="MEMBER_GUID" name="MEMBER_GUID" 
                            type="uuid" minOccurs="0" />
           <xsd:element sql:field="MEMBER_CAPTION" name="MEMBER_CAPTION" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="CHILDREN_CARDINALITY" name="CHILDREN_CARDINALITY" 
                            type="xsd:unsignedInt" minOccurs="0" />
           <xsd:element sql:field="PARENT_LEVEL" name="PARENT_LEVEL" 
                            type="xsd:unsignedInt" minOccurs="0" />
           <xsd:element sql:field="PARENT_UNIQUE_NAME" name="PARENT_UNIQUE_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="PARENT_COUNT" name="PARENT_COUNT" 
                            type="xsd:unsignedInt" 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="MEMBER_KEY" name="MEMBER_KEY" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="IS_PLACEHOLDERMEMBER" name="IS_PLACEHOLDERMEMBER" 
                            type="xsd:boolean" minOccurs="0" />
           <xsd:element sql:field="IS_DATAMEMBER" name="IS_DATAMEMBER" 
                            type="xsd:boolean" minOccurs="0" />
           <xsd:element sql:field="SCOPE" name="SCOPE" type="xsd:int" minOccurs="0" />
         </xsd:sequence>
       </xsd:complexType>
           
  • Last updated on