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.<243> |
|
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.<244>
|
|
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:
|
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>