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:
|
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:
|
MEMBER_WRITABLE |
Determines if user has write permission on this element. The valid values are:
The element is writable if you can use it as a coordinate during a cell write operation. This is driven by DAC permission cube. |