Applies To: SQL Server 2016 Preview
Describes the members within a database.
The MDSCHEMA_MEMBERS rowset contains the following columns.
|Column name||Type indicator||Length||Description|
|CATALOG_NAME||DBTYPE_WSTR||The name of the database to which this member belongs.|
|SCHEMA_NAME||DBTYPE_WSTR||The name of the schema to which this member belongs.|
|CUBE_NAME||DBTYPE_WSTR||The name of the cube to which this member belongs.|
|DIMENSION_UNIQUE_NAME||DBTYPE_WSTR||The unique name of the dimension to which this member belongs.|
|HIERARCHY_UNIQUE_NAME||DBTYPE_WSTR||The unique name of the hierarchy to which this member belongs.|
|LEVEL_UNIQUE_NAME||DBTYPE_WSTR||The unique name of the level to which this member belongs.|
|LEVEL_NUMBER||DBTYPE_UI4||The distance of the member from the root of the hierarchy. The root level is zero (0).|
|MEMBER_ORDINAL||DBTYPE_UI4||(Deprecated) Always returns 0.|
|MEMBER_NAME||DBTYPE_WSTR||The name of the member.|
|MEMBER_UNIQUE_NAME||DBTYPE_WSTR||The unique name of the member.|
|MEMBER_TYPE||DBTYPE_I4||The type of the member:|
MDMEMBER_TYPE_FORMULAtakes precedence over MDMEMBER_TYPE_MEASURE. For example, if there is a formula (calculated) member on the Measures dimension, it is listed as MDMEMBER_TYPE_FORMULA.
|MEMBER_GUID||DBTYPE_GUID||The GUID of the member. NULL if no GUID exists.|
|MEMBER_CAPTION||DBTYPE_WSTR||A label or caption associated with the member. Used primarily for display purposes. If a caption does not exist, MEMBER_NAME is returned.|
|CHILDREN_CARDINALITY||DBTYPE_UI4||The number of children that the member has. This can be an estimate, so consumers should not rely on this to be the exact count. Providers should return the best estimate possible.|
|PARENT_LEVEL||DBTYPE_UI4||The distance of the member's parent from the root level of the hierarchy. The root level is zero (0).|
|PARENT_UNIQUE_NAME||DBTYPE_WSTR||The unique name of the member's parent. NULL is returned for any members at the root level.|
|PARENT_COUNT||DBTYPE_UI4||The number of parents that this member has.|
|DESCRIPTION||DBTYPE_WSTR||This column always returns a NULL value.|
This column exists for backwards compatibility
|EXPRESSION||DBTYPE_WSTR||The expression for calculations, if the member is of type MDMEMBER_TYPE_FORMULA.|
|MEMBER_KEY||DBTYPE_WSTR||The value of the member's key column. Returns NULL if the member has a composite key.|
|IS_PLACEHOLDERMEMBER||DBTYPE_BOOL||A Boolean that indicates whether a member is a placeholder member for an empty position in a dimension hierarchy.|
It is valid only if the MDX Compatibility property has been set to 2.
|IS_DATAMEMBER||DBTYPE_BOOL||A Boolean that indicates whether the member is a data member.|
Returns True if the member is a data member.
|SCOPE||DBTYPE_I4||The scope of the member. The member can be a session calculated member or global calculated member. The column returns NULL for non-calculated members. This column can have one of the following values:|
|Zero or more additional columns||DBTYPE_UI2||No properties are returned if the members could be returned from multiple levels. For example, if the Tree operator is PARENT and SELF for a non-parent child hierarchy, no member properties are returned.|
This applies to ragged hierarchies where tree operators could return members from different levels (for example, if the prior level contains holes and parent on members is requested).
The rowset is sorted on CATALOG_NAME, SCHEMA_NAME, CUBE_NAME, DIMENSION_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, LEVEL_UNIQUE_NAME, LEVEL_NUMBER, MEMBER_ORDINAL.
The MDSCHEMA_MEMBERS rowset can be restricted on the columns listed in the following table.
|Column name||Type indicator||Restriction State|
|TREE_OP||DBTYPE_I4||(Optional) Only applies to a single member:|
MDTREEOP_ANCESTORS (0x20) returns all of the ancestors.
MDTREEOP_CHILDREN (0x01) returns only the immediate children.
MDTREEOP_SIBLINGS (0x02) returns members on the same level.
MDTREEOP_PARENT (0x04) returns only the immediate parent.
MDTREEOP_SELF (0x08) returns itself in the list of returned rows.
MDTREEOP_DESCENDANTS (0x10) returns all of the descendants.
|CUBE_SOURCE||DBTYPE_UI2||(Optional) Default restriction is a value of 1. A bitmap with one of the following valid values:|