Skip to main content

Pentaho+ documentation has moved!

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


Hitachi Vantara Lumada and Pentaho Documentation


Parent article

Member property that enables you to create subcategories for levels and hierarchies.


AttributeData TypeDefinition
nameStringThe display name of this property
columnStringThe data column that will determine this subcategory's content
typeStringData type of this property: String, Numeric, Integer, Boolean, Date, Time or Timestamp
formatterStringName of a formatter class for the appropriate property value being displayed. The class must implement the mondrian.olap.PropertyFormatter interface.
captionStringA string being displayed instead of the name. Can be localized from Properties file using #{propertyname}.
descriptionStringDescription of this member property. Can be localized from Properties file using #{propertyname}.
dependsOnLevelValueBooleanShould be set to true if the value of the property is functionally dependent on the level value. This permits the associated property column to be omitted from the GROUP BY clause (if the database permits columns in the SELECT that are not in the GROUP BY). This can be a significant performance enhancement on some databases, such as MySQL.

Constituent Elements