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 DimensionUsage is usage of a shared dimension within the context of a cube.


AttributeData TypeDefinition
sourceStringName of the source dimension. Must be a dimension in this schema. Case-sensitive.
levelStringName of the level to join to. If not specified, joins to the lowest level of the dimension.
usagePrefixStringIf present, then this is prepended to the Dimension column names during the building of collapse dimension aggregates allowing 1) different dimension usages to be disambiguated during aggregate table recognition and 2) multiple shared dimensions that have common column names to be disambiguated.

Constituent Elements