Searching Members

  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 .

   The results of the search populate the Available pane.

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

7. Click OK.