Searching for Members

  To search for members, within a selected dimension, that match a pattern string in Query Designer:

  1. In the navigation panel, select a dimension.

    The dimension and its members are displayed in the member select panel.

  2. In the member select panel, select a member.

  3. Right-click and select Find from the shortcut menu.

  4. In Find Members, enter the text string to be searched (a member name or pattern).

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

  5. To locate the first member within the selected dimension that matches the text string, click Find.

  6. 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 within the selected dimension are found.

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

  7. Optional: To add the member to the selection, click Add Rule.

  8. Repeat step 1 through step 7 to search for members within another dimension.

  9. Click Close.

Next, you can apply additional filters to the member selection to locate members that meet criteria.

Related Topics

Applying Member Filtering Rules

Deleting Member Selection Rules

Displaying Aliases

Selecting Attribute Members

Selecting Query Members

Setting the Maximum Number of Members to Preview

Specifying Latest Period of Time Dimensions

Suppressing Shared Members

Using Attributes to Select Base Dimension Members

Viewing Member Information