Skip to main content

Pentaho+ documentation has moved!

The new product documentation portal is here. Check it out now at docs.hitachivantara.com

 

Hitachi Vantara Lumada and 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. See the Format class under mondrian.util in https://mondrian.pentaho.com/api/index.html for more details.
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.