Searching for Members

The Essbase Member Selection dialog box enables you to do pattern match searches for members in the selected dimension. Essbase accepts these wildcard symbols: trailing asterisk, *, and single-character match, ?.

  To search for a member:

  1. Select Essbase, and then Member Selection.

  2. In Essbase Member Selection, click Find.

  3. In Find Member, enter the text string (a member name or pattern) you want to search for.

    Examples of valid text strings are: Ja*, M?n, and M??n. Examples of invalid text strings are: *-10 and J*n.

  4. To find the first member within the dimension that matches the text string, click Find.

  5. Click Find Next (if available) to search for the next occurrence of the text string.

    Continue to click Find Next until all matching text strings are found.

    If Find Next is not available, all occurrences of the text string are found.

    The Find Member dialog box locates the members that match the text string in outline order and keeps them selected so that they can be added to the Rules list box as a group.

  6. Click Close.

Related Topics

Clearing All Member Selections

Previewing Members

Removing Members from Rules

Reordering Member Display in Worksheets

Saving Member Selections

Selecting Members Using Attributes

Selecting Members to Add to Worksheets

Specifying Latest Period To-Date

Specifying Member Criteria

Specifying Member Layout in Worksheets

Specifying View Methods

Suppressing Shared Members

Viewing All Members

Viewing Member Formulas