Skip to main content
Pentaho Documentation

CalculatedMember

Parent article

A member whose value is derived using a formula, defined as part of a cube.

Attributes

AttributeData TypeDefinition
nameStringName of this calculated member
formatStringStringFormat string with which to format cells of this member. For more details, see {@link mondrian.util.Format}.
captionStringA string being displayed instead of the name. Can be localized from Properties file using #{propertyname}.
descriptionStringDescription of this calculated member. Can be localized from Properties file using #{propertyname}.
formulaStringMDX expression which gives the value of this member. Equivalent to the Formula sub-element.
dimensionStringName of the dimension which this member belongs to
hierarchyStringName of the hierarchy that this member belongs to
parentStringFully-qualified name of the parent member. If not specified, the member will be at the lowest level (besides the 'all' level) in the hierarchy.
visibleBooleanWhether this member is visible in the user-interface. Default true.

Constituent Elements

ElementDefinition
FormulaMDX expression which gives the value of this member.
CalculatedMemberPropertyProperty of a calculated member.