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 thenavigation 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 Properties for List of Filters dialog box (seeInserting 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
General Tab
Dimensions Tab
Name for List of Filters	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.
Data Providers	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. SeeConfiguring Data Providers
Range	Manipulate coordinates for a cell or cells in this field to move or resize the list of filters. SeeMoving and Resizing Design Items
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.
Available Dimensions	Lists all the available dimensions in the query. Select a dimension in this list and choose the Add Selected Dimensions to 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 Displayed Dimensions button to remove it, or the Move Selected Displayed Dimension Up or Move 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