Finding Dimension Members

You can use the Point of View dialog box to quickly find a member within a large dimension. In addition to providing search capabilities, the Point of View dialog box displays your location in the dimension hierarchy.

You can use wildcards before, after, or within the member name; for example, *con, con*, or *con*. To find the Massachusetts entity, for example, type ma*. The search defaults to the first member with a name that starts with “ma.” When you press Enter, the cursor moves to the next member that fits the criteria.

To find dimension members from the Member Selector:

1. From the Point of View bar, click a dimension.

2. Optional: From the Member Selection dialog box, click Enable/disable filter selection on the text for the search criteria.

3. In the text box, type in the member name that you are looking for. The search only applies to the member label, not the description.

   Tip:

   Use an asterisk (*) as a wildcard, for example, Sales*.

4. Click Find Down. If a matching member is found, it is highlighted. If there are more matching members, click Find Down to display the next result.

   Tip:

   Use Find Up and Find Down to navigate through the search result.

5. When you find and select a member, click the Shuttle Right arrow to move it to the selected members list.

6. Click OK.

To find dimension members from the Add Member text box:

1. From the Point of View bar, Ctrl + left-click on a dimension to display the Add Member text box.

2. Type the member name in the text box.

   Note:

   You must enter the member label, not the description.

3. Click the green Arrow button next to the text box to find the member.