Searching for Members

Analytic Services and Financial Management users can locate members in large dimensions by using search criteria. Searches can be conducted inside Dimension Browser (during query creation) or from the data-object right-click menu (during document analysis).

  To search for Analytic Services or Financial Management members in Dimension Browser:

  1. Right-click a member.

  2. Select Search.

  3. Enter search criteria in the text boxes.

    Table 15. Member Search Criteria 

    Search Criteria

    Control

    Description

    Member

    		 

    Searches by text string

    Mode

    ID

    Searches by member name

     

    Description

    Searches by member alias

     

    Both

    Searches by ID and description (Financial Management data sources only)

     

    Find In Tree

    If Expand Tree is selected, adds found members to the Selections list and expands the Browse node tree to display the members in the hierarchy (only the first search-criteria instance is selected)

    If Expand Tree is not selected, adds found members to the Selections list

    Range

    		 

    Searches the entire dimension or down the hierarchy from the right-clicked member

    Option

    Whole

    Searches for the whole member name or alias

     

    Substring

    Searches for the first, last, or middle part of the member name, in the order entered in the member text box

     

    Beginning

    Searches for the start of the member string

     

    Ending

    Searches for the end of the member string.

  4. Click OK.

  To search for Analytic Services members in a Web Analysis data object:

  1. Right-click a member, and select Search from the right-click menu.

  2. Enter search criteria in the text boxes, and click OK.

    Note:

    Search performance is directly related to size and complexity of the dimension hierarchy.