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:
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:
| |
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. |
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.
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.