Searching For SAP BW Characteristic Values

SAP BW users can locate characteristic values in large dimension hierarchies using search criteria. These searches can be conducted only inside the Dimension Browser dialog box when composing a query.

  To locate SAP BW dimension members in Dimension Browser:

  1. Right-click a dimension member, and select Search.

  2. Enter search criteria in the corresponding text boxes.

    Search Criteria

    Control

    Description

    Mode

    ID

    Searches by member technical name.

     

    Description

    Searches by member alias (description).

    Search Criteria

     

    A list enables selection from these operands:

    • Equal To

    • >=

    • <=

    • >

    • <

    • Between

    • Contains Pattern

      

    Enter the text string for the search function in the text area.

    Supports the wildcard characters * and +.

    Execute

     

    Runs the search function.

    Filtered Members

     

    Displays the search result set.

     

    Add

    Adds the currently selected member from the Filtered Members list to the Selected Members list.

     

    Remove

    Removed the currently selected member from the Selected Members list back to the Filtered Members list.

    Selected Members

     

    Displays potential member selections made from the search result set.

     

    Add All

    Adds all Filtered Members to the Selected Members list.

     

    Remove All

    Removes all Selected Members back to the Filtered Members list.

    OK

     

    Adds the Search Selected Members list to the Dimension Browser Selections list.

  3. Click Execute to run the search function using the criterion specified in the Mode and Search Criteria groups.

    The search result set is displayed in the Filtered Members group.

  4. Select members from Filtered Members, and click Add to add them to Selected Members.

    Only the members added to the Selected Members list are added to the Dimension Browser Selections list when you click OK.

  5. Click OK.