Skip to main content
Pentaho Documentation


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.


Attribute Data type Definition
name String The name of this dimension.
type String The 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".
caption String A string being displayed instead of the dimensions's name. Can be localized from Properties file using #{propertyname}.
usagePrefix String If 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

Element Definition
Hierarchy The hierarchies (pre-defined drill-downs) for this dimension.