Searching Members

Use the Member Selection Search tab to find members within a dimension that match a pattern string in Essbase.

Note:

The Search feature is also available in the Catalog.

Note:

Only the member names and aliases are displayed and not the fully qualified name (for example, [West].[Salem] ) in the Member Selection, Catalog or query results.

  To search for members:

  1. In the data layout, right click a dimension and select Edit.

  2. Select Search.

  3. From the Member Type, select the type of member to search:

    • Name—Member Name

    • Alias—Alternate Names for database members

    • Both—Member Name and Alias Name

    Note:

    To search on alias names, enable the Use Alias Tables option and select an alias table in Query Options.

  4. Enter the text string or numeric value to search (a member name or pattern).

    Trailing asterisks and wildcard strings are acceptable. Examples of value text strings: Ja*, M?n, and M??n. Examples of invalid text strings: *-10 and J*n.

  5. To locate all member within the selected dimension that matches the text string or numeric value, click Search icon.

    The results of the search populate the Available pane.

  6. Optional: To add a member to the Selected pane, click Include icon.

  7. Click OK.