Mandatory Member Properties

  • Article

All providers are required to support the following properties for each member:

  • CATALOG_NAME

  • SCHEMA_NAME

  • CUBE_NAME

  • DIMENSION_UNIQUE_NAME

  • HIERARCHY_UNIQUE_NAME

  • LEVEL_UNIQUE_NAME

  • LEVEL_NUMBER

  • MEMBER_UNIQUE_NAME

  • MEMBER_NAME

  • MEMBER_TYPE

  • MEMBER_GUID

  • MEMBER_CAPTION

  • MEMBER_ORDINAL

  • CHILDREN_CARDINALITY

  • PARENT_LEVEL

  • PARENT_UNIQUE_NAME

  • PARENT_COUNT

  • DESCRIPTION

The meanings of these properties are the same as the respective columns of the MEMBERS rowset. For more information, see MEMBERS Rowset.

The consumer can include any of these properties in the axis rowset by specifying them in the DIMENSION PROPERTIES clause.