Searching for SAP BW Characteristics

SAP BW users can locate characteristics in large dimension hierarchies by using search criteria. The searches can be conducted only inside Dimension Browser during composition of a query.

  To locate SAP BW members in Dimension Browser:

  1. Right-click a member.

  2. Select Search.

  3. Enter search criteria in the text boxes.

    Table 16. SAP BW Search Criteria 

    Search Criteria

    Control

    Description

    Mode

    ID

    Searches by member technical name

     

    Description

    Searches by member alias

    Search Criteria

     

    Searches using an operand:

    • Equal To

    • >=

    • <=

    • >

    • <

    • Between

    • Contains Pattern

      

    Searches by text string.

    Execute

     

    Runs the search function

    Filtered Members

     

    Displays the search result set

     

    Add

    Moves the selected member from the Filtered Members list to the Selected Members list.

     

    Remove

    Moves the selected member from the Selected Members list to the Filtered Members list

    Selected Members

     

    Displays members of the search result set

     

    Add All

    Moves all filtered members to the Selected Members list

     

    Remove All

    Moves all selected members to the Filtered Members list

    OK

     

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

  4. Click Execute to run the search function using the criteria specified in the Mode and Search Criteria group boxes.

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

  5. Select members from the Filtered Members list, and click Add to add them to the Selected Members list.

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

  6. Click OK.