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 member 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 |
 | Select Next/Previous | Opens the Select Next/Previous dialog box so that a user can select a number of next or previous members at the same dimension level as the selected member |
 | Subset | Opens the Subset dialog box to further define the member criteria for selections such as level, generation, user defined attributes, and attribute dimensions |
 | Date Time Series | Opens the Date Time Series dialog so that a user can select the latest time period to be reported |
Note: | When a Shared Member is individually selected, Essbase treats it as the initial occurrence, and not the shared occurrence of the member. If selection functions such as “Siblings” and “Select Next/Previous” are used with shared members, the returned members reflect the original occurrence of the member. For example in the Sample Basic Product dimension, if the shared member “100-20” (under the Diet member) is selected with the Siblings selection type, the results are (100-10, 100-20 & 100-30) and not (100-20, 200-20, & 300-30). This occurs because the original occurrence of the member, under the parent “100” is used by Essbase |