Dimension properties

This table describes the dimension properties:
Property Description
CATALOG_NAME The name of the catalog to which the element belongs.
CHILDREN_CARDINALITY The number of children that the element has. This can be an estimate.
CUBE_NAME The name of the cube to which the element belongs.
DESCRIPTION A human-readable description of the element.
DIMENSION_UNIQUE_NAME The unique name of the dimension to which this element belongs.
HIERARCHY_UNIQUE_NAME The unique name of the hierarchy.
LEVEL_NUMBER The distance of the element from the root of the hierarchy. The root level is zero.
LEVEL_UNIQUE_NAME The unique name of the level to which the element belongs.
MEMBER_CAPTION A label or caption associated with the element.
MEMBER_GUID This is not supported.
MEMBER_NAME The name of the element.
MEMBER_ORDINAL The unique element ordinal number.
MEMBER_TYPE Specifies whether a element is a measure or regular element. The valid values are:
  • Unknown: 0
  • Regular: 1
  • All: 2
  • Measure: 3
  • Formula: 4
MEMBER_UNIQUE_NAME The unique name of the element.
PARENT_COUNT Determines if the element has a parent (1) or not (0).
PARENT_LEVEL The distance of the element's parent from the root level of the hierarchy. The root level is zero.
PARENT_UNIQUE_NAME The unique name of the element's parent.
IS_PLACEHOLDERMEMBER This is for internal use.
NAME The name of the element.
ID The internally maintained ID for the element.
KEY The name of the element.
CAPTION A label or caption associated with the element.
MEMBER_WEIGHT Determines how a child element rolls up to its immediate parent. The valid value is any number.
ELEMENT_TYPE Specifies whether a element is base, consolidated or string. The valid values are:
  • B: base
  • C: consolidated
  • S: string
MEMBER_WRITABLE Determines if user has write permission on this element. The valid values are:
  • True if the user has write permission.
  • False if the user does not have write permission.

The element is writable if you can use it as a coordinate during a cell write operation. This is driven by DAC permission cube.