Skip to main content
Pentaho Documentation

Hierarchy

Defines a hierarchy, which is a pre-defined drill-down.

Note: You must specify at most one <Relation> or memberReaderClass. If you specify none, the hierarchy is assumed to come from the same fact table of the current cube.

Attributes

Attribute Data type Definition
name String Name of the hierarchy. If this is not specified, the hierarchy has the same name as its dimension.
hasAll Boolean Whether this hierarchy has an 'all' member.
allMemberName String Name of the 'all' member. If this attribute is not specified, the all member is named 'All hierarchyName', for example, 'All Store'.
allMemberCaption String A string being displayed instead as the all member's name. Can be localized from Properties file using #{propertyname}.
allLevelName String Name of the 'all' level. If this attribute is not specified, the all member is named '(All)'. Can be localized from Properties file using #{propertyname}.
primaryKey String The name of the column which identifies members, and which is referenced by rows in the fact table. If not specified, the key of the lowest level is used. See also CubeDimension.foreignKey.
primaryKeyTable String The name of the table which contains primaryKey. If the hierarchy has only one table, defaults to that; it is required.
defaultMember String  
memberReaderClass String Name of the custom member reader class. Must implement the mondrian.olap.MemberReader interface.
caption String A string to be displayed in the user interface. If not specified, the hierarchy's name is used. Can be localized from Properties file using #{propertyname}.

Constituent elements

Element Definition
RelationOrJoin (as <Table>, <View>, <Join>, or <InlineTable>) The Table, Join, View, or Inline Table that populates this hierarchy.
Level