The Dimension Hierarchy Toolbar

 

The buttons on the toolbar in the Dimension Hierarchy dialog box, and the functions they perform—all of which have been referenced in the preceding pages—are as follows:

 

Dimension Hierarchy Toolbar

Command

Icon

Description

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.

Properties

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).

Help

Access the help screen for the Dimension Hierarchy.

OK

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