Searching Members from the Catalog

Member search is available for member names, aliases or both in one or more dimensions from the Catalog. If the Catalog shows members in single dimension mode, the Search is performed on a selected dimension. If all dimensions are displayed, Search is performed on all dimensions.

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 members from the Catalog:

  1. Select to search by name, alias, or both.

  2. Enter the text on which to search.

    If you use wildcards in searches, only trailing wildcards are accepted (for example, Cola*), and not leading wildcards (for example, *-10).

    The ?? (placement position) is a valid search criteria. The ? substitutes one occurrence of a character; and can be placed anywhere in the string.

  3. Click Search icon.

    The search results are displayed in the Catalog, and they can be added to the data layout.

  To close Search, click No Search icon.

The Search results are cleared.