MEMBERS Rowset

The MEMBERS rowset contains information about the available members. It has the following structure:

Column name Type indicator Description
CATALOG_NAME DBTYPE_WSTR The name of the catalog to which this member belongs. NULL if the provider does not support catalogs.
SCHEMA_NAME DBTYPE_WSTR The name of the schema to which this member belongs. NULL if the provider does not support schemas.
CUBE_NAME DBTYPE_WSTR Name of the cube to which this member belongs.
DIMENSION_
UNIQUE_NAME		 DBTYPE_WSTR Unique name of the dimension to which this member belongs. For providers that generate unique names by qualification, each component of this name is delimited.
HIERARCHY_
UNIQUE_NAME		 DBTYPE_WSTR Unique name of the hierarchy. If the member belongs to more than one hierarchy, then there is one row for each hierarchy to which it belongs. For providers that generate unique names by qualification, each component of this name is delimited.
LEVEL_
UNIQUE_NAME		 DBTYPE_WSTR Unique name of the level to which the member belongs. For providers that generate unique names by qualification, each component of this name is delimited.
LEVEL_NUMBER DBTYPE_UI4 Member's position (distance from the root level, zero based) of the member.
MEMBER_ORDINAL DBTYPE_UI4 Ordinal number of the member. This is the sort rank of the member when members of this dimension are sorted in their natural sort order. If providers do not have the concept of natural ordering, then this should be the rank when sorted by MEMBER_NAME.
MEMBER_NAME DBTYPE_WSTR Name of the member.
MEMBER_TYPE DBTYPE_I4 The type of the member. Can be one of the following values:
  • MDMEMBER_TYPE_REGULAR

  • MDMEMBER_TYPE_ALL

  • MDMEMBER_TYPE_MEASURE

  • MDMEMBER_TYPE_FORMULA

  • MDMEMBER_TYPE_UNKNOWN

  • Note that MDMEMBER_TYPE_FORMULA takes precedence over MDMEMBER_TYPE_MEASURE. Thus, if there is a formula (calculated) member on the measures dimension, it is listed as MDMEMBER_TYPE_FORMULA.
MEMBER_GUID DBTYPE_GUID Member GUID. NULL if no GUID.
MEMBER_CAPTION DBTYPE_WSTR A label or a caption associated with the member. Used primarily for display purposes. If a caption does not exist, then MEMBER_NAME is returned.
CHILDREN_
CARDINALITY		 DBTYPE_UI4 Number of children that the member has. This can be an estimate of the number of children, and not exact. Consumers should not rely on this being the exact count. Providers should return as good an estimate as possible.
PARENT_LEVEL DBTYPE_UI4 Level number (distance from the root level, zero based) of the member's parent. This has the value 0 for the root level.
PARENT_
UNIQUE_NAME		 DBTYPE_WSTR Unique name of the member’s parent. NULL is returned for any members at the root level. For providers that generate unique names by qualification, each component of this name is delimited.
PARENT_COUNT DBTYPE_UI4 The count of the number of parents that this member has. For more information, see “Complex Member Relationships” in this chapter.
DESCRIPTION DBTYPE_WSTR A human-readable description of the member.
Zero or more columns one for each property of the member Depends on the PROPERTIES rowset A list of zero or more columns, one for each property at this level. The structure of these columns can be gleaned from the PROPERTIES rowset.

The default sort order is: CATALOG_NAME, SCHEMA_NAME, CUBE_NAME, DIMENSION_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, LEVEL_UNIQUE_NAME, LEVEL_NUMBER, and MEMBER_ORDINAL.