List dialog box

Use the List dialog box to select dimension values from a list of available values. You can add values to the list, retain values on the list, and remove values from the list. For a dimension with a hierarchy, you can also access the Drill dialog box to expand or collapse the hierarchy.

Dialog box components

Available Dimension Values box -- Lists all the values in the current hierarchy or, if there is no hierarchy selected, all the values in the dimension. If you want to add values to the current selection or replace the current selection, highlight the values to add or to use in the replacement. Use SHIFT+CLICK or CTRL+CLICK to highlight multiple values, or drag the left mouse over the values you want to highlight.

Drilling column -- If the current dimension has a hierarchy, then a column appears at the left that contain drill icons. You can click on these icons to expand or collapse the hierarchy. At the bottom of this column is a drill button that displays the Drill dialog box.

Selected Dimension Values box -- Lists the dimension values that are currently selected. If you want to keep values in or remove values from the current selection, highlight the values to keep or remove. Use SHIFT+CLICK or CTRL+CLICK to highlight multiple values, or drag the left mouse over the values that you want to highlight.

Select button -- Replaces the current selection (listed in the Selected Dimension Values box) with dimension values that are highlighted in the Available Dimension Values box.

Add button -- Adds the dimension values that are highlighted in the Available Dimension Values box to the current selection in the Selected Dimension Values box.

Keep button -- Keeps the dimension values that are highlighted in the Selected Dimension Values box in the current selection and removes the others.

Remove button -- Removes the dimension values that are highlighted in the Selected Dimension Values box from the current selection and keeps the others.

Hierarchy box -- Lists the hierarchies defined for the dimension. Select the hierarchy from which you want to select dimension values. The values in the hierarchy that you select appear in the Available Dimension Values box.

See also

About selecting Express data

Selector toolbar