Essbase users can locate members in large dimensions using search criteria. These searches can be conducted inside the Dimension Browser dialog box when composing a query, or from the data object shortcut menu when analyzing a document.
To search for Essbase dimension members in Dimension Browser:
Right-click a dimension member in the Dimension Browser, and select Search.
Enter search criteria in the corresponding text boxes, and click OK.
Search Criteria
Control
Description
Member
The text string for the search function.
Mode
ID
Searches by member name.
Description
Searches by member alias (description).
Both
Financial Management data source enables you to search by ID and Description, using this option.
Expand Tree
When the Expand Tree option is selected, not only is the found member added to the Selections list, but the Browse node tree is expanded to display the found member in the dimension hierarchy. Only the first instance of the search criteria is selected.
When the Expand Tree option is not selected, found members are added to the Selections list, without changing the Browse node tree.
Range
Specifies the search of the dimension (All Top Members), or down the hierarchy from the selected member.
Option
Whole
Searches on exact match with fully qualified member name or alias.
Substring
Searches for the first, last, or middle part of the member, in the order entered in the member text box.
Beginning
Searches for the start of the member string.
Ending
Searches for the end of the member string.