An Essbase database may contain hundreds or even thousands of members. Use the Member Selection Browse and Search tabs to refine query member criteria for a selected dimension. The Member Selection dialog box includes dynamic selection functions such as children, descendants, bottom, siblings, or subsets (UDA, Attribute Dimensions, Level and Generation).
The Available pane lists the member hierarchy for the selected dimension. An additional node for substitution variables lists substitution variables for all dimensions; however, if they are selected from another dimension, an error appears when adding the substitution variables to the Selected pane.
The Selected pane lists all member selections. Selections can be a single member or a dynamic selection function (for example, children).
| Icon | Dynamic Function | Description |
|---|---|---|
 | Member | Currently selected member |
 | Children | Children of the selected member (one level below) |
 | Descendants | Descendants of the selected member |
 | Bottom | Descendants of the selected member on the lowest level of the hierarchy (Level 0) |
 | Siblings | Members on the same level with the same parent as the selected member |
 | Same Level | Dimension members on the same level as the selected member |
 | Same Generation | Dimension members on the same generation as the selected member |