The Dimension Hierarchy Toolbar


The buttons on the toolbar in the Dimension Hierarchy dialog box, and the functions they perform, are as follows:

Dimension Hierarchy Toolbar




Create New Member

Add a new Member to a Dimension (or press Ctrl-Enter to successively add new Members).

Member Type

Select formatting option for the corresponding cells.

Member Aliases

Define and edit Aliases and Alias Groups for the selected Member.

Alias Group

Add or delete Alias Groups, and assign names for each Member.


Assign Members a property for annotation purposes. A Member’s properties can be displayed on an Excel worksheet when needed.

Mark Member as Persistent

Tag a Member as ‘persistent’ to prevent its data from being overwritten when updates or Cube re-builds occurs.

Add Selected As Sibling

Insert the current selection in the Member list on the left into the Hierarchy Definition on the right, below the selected Member.

Add All As Sibling

Insert all Members in the Member list after the selected Member in the Hierarchy, making them sibling Members.

Add Selected Members As Child

Insert selected Member(s) in the Member list as children of selected Member in the Hierarchy.

Add All Members As Child

Insert all Members in the Member list as children of selected Member in the Hierarchy.

Specify Member Weights

Edit the weight of a Child member (active only when a Child member is selected in the right hand Hierarchy Definition box).


Accesses the help screen for the Dimension Hierarchy.


Exits the dialog box, with changes made and saved for the Dimension.

The functions listed above are described more fully in the PowerOLAP® User Manual, though we will now discuss Aggregate weights in order to complete our QS Database Dimension set-up.