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

A dimension is a collection of hierarchies. There are two kinds: a public dimension belongs to a schema, and be used by several cubes; a private dimension belongs to a cube. The foreignKey field is only applicable to private dimensions.


AttributeData TypeDefinition
nameStringThe name of this dimension
typeStringThe dimension's type may be one of Standard or Time. A time dimension will allow the use of the MDX time functions (WTD, YTD, QTD, etc.). Use a standard dimension if the dimension is not a time-related dimension. The default value is Standard.
captionStringA string being displayed instead of the dimensions's name. Can be localized from Properties file using #{propertyname}.
usagePrefixStringIf present, then this is prepended to the Dimension column names during the building of collapse dimension aggregates allowing 1) different dimensions to be disambiguated during aggregate table recognition. This should only be set for private dimensions.

Constituent Elements

HierarchyThe hierarchies (pre-defined drill-downs) for this dimension