Make selections from the entire list, or execute a search to narrow down the list. Use the search properties to specify the criteria and the parameters by which to search for hierarchies to add to the rows, columns, or view filter of a view.

Click the Search  button after you specify your search properties:

·         Enter a value in the search field. Multiple values can be entered by separating them with a semicolon. If the field is left blank, the available list displays all hierarchies that are not currently associated with the view.

·         You can search by name. Optionally use the other Search By drop-down list to choose whether you want your search to contain the specified value, start with, or end with the specified value.

In the below example, we searched for hierarchies containing “customer” and eight items were retrieved.

Available Selection list - Use this list to select hierarchies for a row, column, or view filter. The list area displays the hierarchies returned by your search.

Use one of the following methods to select the desired hierarchies from the available selection list in the top portion of the window and move them to the selected list displayed in the bottom portion of the window.

• Select the hierarchies and then click OK. This will add the selected hierarchies and close the window.

• Select the desired hierarchy (ies) from the available selection list and click Add. You can use Ctrl+Click and Shift+Click when selecting more than one hierarchy.

• Double-click a hierarchy in the list.

• Click Add All to add all of the available hierarchies, from all pages. When a hierarchy is added, the hierarchies along with the default attribute relationship(s) are added to the view.

Note:  The available list will contain time hierarchies only if the view is defined with measure item set to time range “No”. When time hierarchies are present, they will be ordered alphabetically along with the other hierarchies.

Selected list - Displays the selected hierarchies for the axis. These hierarchies are not available for re-selection in the top portion of the window.

Use one of the following methods to clear hierarchies:

• Select the desired hierarchy (ies) and click Clear. You can use Ctrl+Click and Shift+Click when selecting more than one hierarchy.

• Double-click a hierarchy in the list.

• Click Clear All to clear all hierarchies, from all pages of the selected list.

Cleared items no longer display in the selected portion of this window but are available for selection in the top portion of the window. When cleared from the selected list, the item is added to the end of the available list section. When a hierarchy is removed, all levels and associated attribute relationships are also removed. If one of the level(s) is referred to in a calculated measure item, the calculated measure item will also be removed.

Reorder buttons – use to reorder the selected hierarchies.

- Moves the selected hierarchy (ies) up one position at a time.

- Moves the selected hierarchy (ies) down one position at a time.

In the example below, the UPC Global Number is moved to the last position by clicking the move down arrow button four times to move it down four positions.