Essbase provides a member selection command that enables you to pick member names from a list, apply subsetting values to further define the selection, perform searches for members, preview your selection, and open and save selection objects.
Member selection is accessed from Spreadsheet Add-in and Partitioning. The dialog box controls that are displayed differ depending on the application used to access member selection.
Dimension—By default, displays the name of the dimension associated with the active cell. Select other dimensions to display from the list. For each dimension selected, members are displayed in the Members list box.
Members—Lists members associated with the dimension displayed in the Dimension list box. You can locate one or more members by expanding dimensional branches. If the view method is set to By Generation Name, By Level Name, or By Dynamic Time Series, the Members list box displays the generation names, level names, or Dynamic Time Series names, respectively. The number in parentheses next to the member indicates how many children the member contains. Members that are marked for Hybrid Analysis are displayed in blue. Use the Dimension list box to select another dimension to display.
Find—Click to display the Find Member dialog box, which you can use to locate members, within the selected dimension, that match a text string.
Clear—Click to clear all selections, including selections hidden in the collapsed hierarchies, from the Members list box.
Latest—Click to display the Select Latest Period dialog box, where you select the level 0 member in a time dimension. For use with the By Dynamic Time Series option only in Partitioning.
Expand to Descendants—Click or enter Alt+x to expand the list in the Members list box to display the descendants for the selected member. If you select multiple members, Essbase displays the descendants for all selected members.
Member Information—Click to display the Member Information dialog box, which provides dimension, generation, level, user-defined attributes, member comments, storage setting and formula information for the selected member. If you select multiple members, Essbase displays the member information for the last member you selected.
By Member Name—Enables you to select members using member names. If the Use Aliases option is also selected, Essbase lists the member names using aliases. By default, the By Member Name option is selected.
By Generation Name—Enables you to select members using generation names. If the Application Designer defined generation names, they appear in this list. Otherwise, Essbase displays the default generation names.
By Level Name—Enables you to select members using level names. If the Application Designer defined level names, they appear in this list. Otherwise, Essbase displays the default level names.
By Dynamic Time Series—Enables you to select Dynamic Time Series members when a time dimension is displayed.
Add—Click to add all selected items, displayed or in collapsed hierarchies, from the Members list box to the Rules list box. Use the selection count below the Members list box to verify the number of items selected. Alternatively, double-clicking an item in the Members list box also adds one member.
Rules—Displays the members you added from the Members list box and all rules you created for the member. Select a member in the Rules list box and click the right mouse button to open a shortcut to further define the members you selected. If duplicate members are selected, hover over the duplicate member names to view the qualified member name.
Move Item Up—Click to change the order in which members are selected for reporting. This button moves the selected item, and its associated subset conditions in the Rules list box, up one position each time you click the button. You can move only the top-level item (the item you added from the Members list box), not the subset conditions.
Move Item Down —Click to change the order in which members are selected for reporting. This button moves the selected item, and its associated subset conditions in the Rules list box, down one position each time you click the button. You can move only the top-level item (the item you added from the Members list box), not the subset conditions.
Remove Item—Click to remove a selected item and its associated subset selection criteria from the Rules list box. The Remove Item button becomes available when you select a top-level item (an item you added from the Members list box).
Remove All—Click to remove all items from the Rules list box.
Use Aliases—Select to display member aliases from the current alias table, when the view method is set to By Member Name. If an alias does not exist for a member, Essbase displays the member name. Select from the list of alias tables associated with this database. To add alias tables, see the Oracle Essbase Administration Services Online Help. By default, this option is not selected.
Suppress Shared Members—Select to prevent shared members from appearing multiple times in the worksheet. This option is available only when the selected items are generation or level names. By default, this option is not selected.
Place Down the Sheet—Select to insert members down a column. When this option is cleared, Essbase inserts members across a row. By default, this option is selected. This option may not be available in all Essbase Member Selection dialog boxes.
Insert List Before Active Cell—Select to insert members before an active cell. When this option is cleared, Essbase overwrites the active cell. By default, this option is cleared.
Open —Click to display the Open Selection Object dialog box, which enables you to select from a list of saved member selections.
Save—Click to display the Save Selection Object dialog box, which enables you to save member selections you defined.
Preview—Click to display the Member Preview dialog box that shows a list of members meeting the selection rules.