Select by Level dialog box

Use the Select by Level dialog box to choose values based on their level in the current dimension hierarchy. For example, you might select all the Geography values at the City level. The Level tool is available only when a hierarchy is defined for the selected dimension.

Dialog box components

Selection Type box -- Contains the following options for the way newly selected values will affect the current selection:

Dimension Values in hierarchy box -- Lists the hierarchies defined for the selected dimension. Select the hierarchy that you want to use.

At level(s) box -- Lists the levels in the selected hierarchy, if any. Select the levels that you want to include in your new selection. Use SHIFT+CLICK or CTRL+CLICK to select multiple levels.

Script box -- Displays the criteria that will be added to the selection script if you choose OK.

Preview button -- Displays the Preview dialog box, which allows you to examine the change you are considering and lists the dimension values that will be selected if you adopt the change.

See also

About selecting Express data

Replacing or refining a selection

Selector toolbar