Text Filter tab
Use the text filter to filter elements by their unique names, captions, or attributes. In a text filter definition, enter a string as the criterion. The elements, in addition to the other filter settings, are filtered by the string.
By default, the Text Filter tab has two columns called Unique Element Name and Element Caption. Select to display any attribute tables that exist for the dimension on which the client list is based. Each attribute is displayed in a separate column of the table.
You can combine unique element names and captions in a filter. For example, to include in the list all elements with the unique name [Period].[All Years].[2002] and all elements with the caption 2003, enter the unique name in the first row of the Unique Element Name column and the caption in the second row of the Element Caption column. The strings are joined by a logical OR operator. If you enter both strings on the same row, they are combined by the AND operator and, in the example given, return no result.
You can also use .NET regular expressions in the Text Filter tab.
| The Text Filter tab | Description |
|---|---|
| Use text filter | Enables the text filter. When you clear the box, any filters you have created remain but are no longer applied to the list. You can re-apply them by selecting the check box again. |
| Additional search fields in | Attribute tables that have been defined for the dimensions are displayed. |
| AND/OR Combinations | If you use several columns of the table, the search strings are combined with the AND operator. To search several strings, enter them into a separate line for each column. An OR combination is applied and the results from the table rows are displayed one after another. |
Filtering element names
Filtering a caption
Open the Client List Designer and select the Text Filter tab. Click a cell in the Element Caption column, enter the string to be filtered and press <Enter>.