The 'all' member
By default, every hierarchy contains a top level called '(All)
', which contains a single member called '(All {hierarchyName})
'. This member is parent of all other members of the hierarchy, and thus represents a grand total. It is also the default member of the hierarchy; that is, the member which is used for calculating cell values when the hierarchy is not included on an axis or in the slicer. The allMemberName
and allLevelName
attributes override the default names of the all level and all member.
If the <Hierarchy>
element has hasAll="false"
, the 'all' level is suppressed. The default member of that dimension will now be the first member of the first level; for example, in a Time hierarchy, it will be the first year in the hierarchy. Changing the default member can be confusing, so you should generally use hasAll="true"
.
The <Hierarchy>
element also has a defaultMember
attribute, to override the default member of the hierarchy:
<
Dimension name="Time" type="TimeDimension" foreignKey="time_id">
<
Hierarchy hasAll="false" primaryKey="time_id" defaultMember = "[Time].[1997].[Q1].[1]"/>