MEMBERS Schema Rowset

Standard Mapping

The MEMBERS schema rowset returns metadata about the members that are available on each cube that can be accessed by the provider. Each row in the MEMBERS schema rowset corresponds to one member that is available in the provider.
The following table describes the columns that are available in the MEMBERS schema rowset.
Standard Mapping
Column Name
Type Indicator
Mapped Value
Restrictions Supported?
CATALOG_NAME
DBTYPE_WSTR
Name of the catalog that contains this member.
Yes
SCHEMA_NAME
DBTYPE_WSTR
Name of the schema that contains this member.
Yes
CUBE_NAME
DBTYPE_WSTR
Name of the cube that contains this member.
Yes
DIMENSION_UNIQUE_NAME
DBTYPE_WSTR
Unique name of the dimension that contains this member.
Yes
HIERARCHY_UNIQUE_NAME
DBTYPE_WSTR
Unique name of the hierarchy that contains this member.
Yes
LEVEL_UNIQUE_NAME
DBTYPE_WSTR
Unique name of the level that contains this member.
Yes
LEVEL_NUMBER
DBTYPE_UI4
Distance from this member to the root of the hierarchy. The LEVEL_NUMBER of the root level is 0.
Yes
MEMBER_ORDINAL
DBTYPE_UI4
Ordinal number of this member.
No
MEMBER_NAME
DBTYPE_WSTR
Name of this member.
Yes
MEMBER_UNIQUE_NAME
DBTYPE_WSTR
Unique name of this member.
Yes
MEMBER_TYPE
DBTYPE_WSTR
Type of this member. The types are as follows:
  • MDMEMBER_TYPE_REGULAR
  • MDMEMBER_TYPE_ALL
  • MDMEMBER_TYPE_FORMULA
  • MDMEMBER_TYPE_MEASURE
  • MDMEMBER_TYPE_UNKNOWN
Yes
MEMBER_GUID
DBTYPE_GUID
GUID of this member.
No
MEMBER_CAPTION
DBTYPE_WSTR
Caption of this member. Same as MEMBER_NAME if no caption exists for this member.
Yes
CHILDREN_CARDINALITY
DBTYPE_UI4
Number of children contained by this member.
No
PARENT_LEVEL
DBTYPE_UI4
Distance from this member's parent to the root level of the hierarchy. The LEVEL_NUMBER of the root level is 0.
No
PARENT_UNIQUE_NAME
DBTYPE_UI4
Unique name of this member's parent.
No
PARENT_COUNT
DBTYPE_UI4
Number of parents of this member.
No
DESCRIPTION
DBTYPE_WSTR
Description of this member.
No
Note: For more information about restrictions, see How to Restrict the Rows That Are Returned.

The Tree Operation Restriction

The MEMBERS schema rowset has a 12th restriction, called tree operation, that does not correspond to an actual column. The tree operation restriction identifies the relationship between the returned members and the member specified in the MEMBER_UNIQUE_NAME restriction. These values can be bitwise-combined by using OR to form a bitmask that represents all returned rows. The following table displays the tree operation values and the relationships that they identify.
Relationship of Returned Members to the Specified MEMBER_UNIQUE_NAME
Tree Operation (Returned Members)
Relationship to Specified MEMBER_UNIQUE_NAME
MDTREEOP_ANCESTORS
Ancestors of MEMBER_UNIQUE_NAME
MDTREEOP_CHILDREN
Immediate children of MEMBER_UNIQUE_NAME
MDTREEOP_SIBLINGS
Members on the same level as MEMBER_UNIQUE_NAME
MDTREEOP_PARENT
Immediate parent of MEMBER_UNIQUE_NAME
MDTREEOP_SELF
MEMBER_UNIQUE_NAME itself
MDTREEOP_DESCENDANTS
All of the descendants of MEMBER_UNIQUE_NAME
Copyright © SAS Institute Inc. All rights reserved.