List of Filters
Definition
The list of filters design item lists all currently active filters set on selected dimensions in the query results.
Use
This item simply displays a list of active filters for one or more dimensions. Since the navigation pane also displays currently active filters, this item might be useful if you have suppressed the display of filters in the navigation pane (by deselecting Display Filter Texts in the navigation pane properties), or if you don’t display a navigation pane at all in your workbook and yet you want to display the current status of filters.
Structure
Configure properties for the list of filters on two different tabs in the Filter List Properties dialog box (see Inserting Design Items to learn about how to insert the list of filters and access its properties):
· General – lets you configure data provider, cell range, and characteristic text display
· Dimensions – lets you select the dimensions for which to display filters
Filter List Properties
Property |
Description |
Filter List Name |
Displays the name of the list of filters, which is generated automatically and is unique. This name is used on the BEx Analyzer → Design Toolbar menu to refer to a particular instance of the list of filters. |
Display Technical Names / Do Not Display Technical Names |
Use this button on any tab to toggle the display of technical names. |
General Tab |
|
Data Provider |
Assign an existing data provider to the list of filters, create and assign a new one, or change or delete a data provider. The initial view of a data provider corresponds to a query or query view. |
Range |
Manipulate coordinates for a cell or cells in this field to move or resize the list of filters. |
Display Characteristic Text |
Select this checkbox to display the name of the dimension in a field next to the list of its selected filters. This acts as a sort of label for each selected dimension in the filter list. |
Dimensions Tab |
|
Available Dimensions |
Lists all the available dimensions in the query. Select a dimension in this list and choose the Add the Selected Dimensions to the Displayed Dimensions button to transfer it to the Selected Dimensions list. You determine in this way the dimensions for which to display a list of filters. By default, all dimensions are displayed. |
Selected Dimensions |
Lists the dimensions for which you have chosen to display filters, and allows you to reorder or remove them. By default, all dimensions are displayed although this list is empty. Select a dimension in this list and choose the Remove Selected Dimensions from the Displayed Dimensions button to remove it, or the Move the Selected Displayed Dimension Up or Move the Selected Displayed Dimension Down buttons to reorder it. |
Presentation Style |
Determines how the filter values are displayed in the list. Select from the following values: · Key: Display technical key · Key and Text: Display technical key, followed by text · Text and Key: Display text, followed by technical key · Text: Display text |
See also: