Hierarchy
Defines a hierarchy, which is a pre-defined drill-down.
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 | A level of a hierarchy |