Analysis Services Programming
MDSCHEMA_MEMBERS
This schema rowset describes the members contained in a database.
Microsoft® SQL Server™ 2000 Analysis Services extends the OLE DB specification with the addition of the following columns to this schema rowset.
| Column name | Type indicator | Description |
| MEMBER_KEY | DBTYPE_WSTR | Contains the key property for the member. |
| IS_PLACEHOLDERMEMBER | DBTYPE_BOOL | 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 1. |
| IS_DATAMEMBER | DBTYPE_BOOL | Contains TRUE if the member is a data member. |
Restriction Columns
CATALOG_NAME
SCHEMA_NAME
CUBE_NAMEDIMENSION_UNIQUE_NAME
HIERARCHY_UNIQUE_NAME
IS_EMPTYMEMBER
IS_DATAMEMBER
LEVEL_UNIQUE_NAME
LEVEL_NUMBER
MEMBER_NAME
MEMBER_UNIQUE_NAME
MEMBER_CAPTION
MEMBER_TYPE
Tree operator
For more information about the MDSCHEMA_MEMBERS schema rowset, see the OLE DB documentation.