## 4.3.1.1 To filter data by member
## Context
You can filter members of a dimension to create new views of your data. You can define the number of members displayed in the filter dialog in the User options.
If a dimension has more members than defined in the User options, the filter dialog for mass data is opened. In this dialog, you only see the selected members, but you can add all other members of the dimension using the input help.
The filter dialog for mass data can be disabled in the registry. For more information, contact your IT Administrator.
## Procedure
1. Select a cell in the crosstab that belongs to the dimension you want to use for filtering.
2. Choose Filter Filter by Member .
The Filter by Member dialog box appears.
If you want to filter for a range of members, you can start the filter dialog directly in the range view by choosing if you want to filter individual members of the dimension. Filter Filter by Range . When working with large master data tables, this avoids that all master data values have to be loaded.

##  Note
You can also open this dialog box using the context menu on the crosstab or the design panel.
3. Select Individual Selection
- a. If you want to search for members, clear the Select All checkbox in the members list and enter a search string in the entry field. In the dropdown list of the search button, you can select if you want to search for a key, a text or a member attribute.
Members that match the search string are displayed in the members list and can be selected.
b.
With the
Display list, you can select how the members are displayed in the list. The following options
are available: Key, Text, Text and key, Key and text and the member attributes.
##  Note
If no text is defined for a member, the key is displayed as text. Members without text are displayed first in the filter dialog. Even if the key is displayed as text, the search for text is not possible if no text is defined. The result list will be empty.
You can also select the Access Mode and Explicit Selection .
The Access Mode option is available only if you select the check box Show Access Mode for Member Display in the Advanced options dialog.
The Explicit Selection option could be useful if you do not have the authorization to see all members of a dimension. If the option is not active and you select Select All , no crosstab will be rendered as you do
not have the authorization to see all members. If the Explicit Selection option is active and you select Select All , the single members you are authorized to see, will be selected and displayed in a crosstab.
You can save an Explicit Selection with a workbook. Note that if your authorizations change and you are authorized to see additional members, they will not be selected automatically when you reopen the workbook. You need to select them manually.
- c. Choose the Show Selected button if only the selected members should be displayed. The button name changes to Show All . Choose this, if you want all members to be displayed again.
- d. Select the members that you want to use for filtering in the members list.
In the members list, all members are selected in the default setting. To deselect a member, clear the corresponding checkbox. You can also deselect all members by clearing the Select All checkbox and selecting individual members from the list.
Note: To select and deselect members in the list, you can click the checkbox or the text next to the checkbox.
4. Select Range Selection if you want to filter for a range of members.
- a. Select an operator.
The following operators are available: Between, Not Between, Greater Than, Greater Than Or Equal To, Less Than, Less Than Or Equal To, Equal To and Not Equal To.
- b. Select the member range.
For the range definition, the key of the members is relevant, not the text.
- c. Select Add Range . The range is added to the Range area. Y ou can add several ranges to the filter.
5. Paste members from a file or from clipboard.
You can paste members, exclude members and paste ranges:
Example for pasting a list of members: 1; 2; 3 (select the members 1, 2, 3).
Example for excluding a list of members: !1; !2; !3 (exlude the members 1, 2, 3).
Example for pasting a range: &gt;=1 (select all members greater or equal to 1).
You can use the following operators for ranges: &gt; (greater than), &gt;= (greater than or equal to), &lt; (less than), &gt;= (less than or equal to), = (equal to), != (not equal to) and 1 - 3 (interval for member 1 to 3). The syntax for intervals requires a space character before and after the minus sign.
You can copy a single or a list of members to the clipboard and paste your selection to the filter dialog using the Paste from Clipboard icon at the left bottom of the filter dialog.
You can paste a single or a list of members using the Paste from File icon at the left bottom of the filter dialog. An open dialog appears and you can select a text file (e.g. a .txt file) with members in the Windows explorer. .
The members that you want to paste can be displayed as either text or key in the list. For pasting ranges or excluding members, the members must be displayed as key.
If you want to paste members that are displayed as key in the list, select Key or Key and text as Display option. If you want to paste members that are displayed as text in the list, select Text or Text and key as Display option. Members defined without text in BW cannot be pasted as text.
If you copy a list of members, you can use one of the following separators: \r\n (new line), \t (tab), ; (semicolon), | (pipe), : (colon). The sequence the separators are listed here, is relevant for their recognition as separator, that means if new lines are used as separator in the pasted list of members, a semicolon
in the list will not be recognized as separator. But if semicolons and pipes are used in the pasted list, the semicolon is the identified separator.
After pasting values from the clipboard or file, the copied members are selected in the member list.
6. Press OK to apply the filter to your data.
## Results
The data in the worksheet is filtered according to your selection. The filter is saved with the workbook and is available to other users or in other sessions. You can also open and edit existing filters again.