Searching Filter Members

Use the Search tab of Filter Selection dialog to search for members within selected 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 for members:

  1. In the Filter pane of the data layout, right click a member and select Edit.

  2. Select Search

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

    • Name—Member Name

    • Alias—Alternate Names for database members

    • Both—Member Name and Alias Name

  4. Type the text string or numeric value to search in the text box.

    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. Click Search icon to locate all members within the selected dimension that match the text string or numeric value.

    Hovering the mouse over an item in the Location column shows a tooltip with the member's full location path.

    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.

    Note:

    To add a different member as a filter, first remove the selected member.

    Note:

    A Search by Alias name searches the currently selected Alias Table in Query Options when the Use Aliases option is enabled.