Skip to main content

Pentaho+ documentation is moving!

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


Hitachi Vantara Lumada and Pentaho Documentation


Parent article

A cube is a collection of dimensions and measures, all centered on a fact table.


AttributeData TypeDefinition
nameStringName of this cube
captionStringA string being displayed instead of the cube's name. Can be localized from Properties file using #{propertyname}.
defaultMeasureStringThe name of the measure that would be taken as the default measure of the cube
cacheBooleanShould the Fact table data for this Cube be cached by Mondrian or not. The default action is to cache the data.
enabledBooleanWhether element is enabled - if true, then the Cube is realized otherwise it is ignored.

Constituent Elements

Relation (as <Table>, View<View>, or <InlineTable>)The fact table is the source of all measures in this cube. If this is a Table and the schema name is not present, table name is left unqualified
CubeDimensionDefines a dimension -- a collection of hierarchies
MeasureSpecifies an aggregated numeric value
CalculatedMemberCalculated members in this cube
NamedSetNamed sets in this cube