Skip to main content
Pentaho Documentation

Cube

Parent article

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

Attributes

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

ElementDefinition
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