Skip to main content
Pentaho Documentation

Dimension

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.

Attributes

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

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