To access the filter panel in edit mode, select the filter icon located on the dimension you want to filter.
The filter option is also available in the analysis work pane above an attribute heading.
When accessing the filter pane, all elements included in the attribute are selected by default (see the figure below).
All the above-selected elements can be deselected with the Select all parameter. You can use the search field to find specific elements in the attribute.
Searching can be aggregated using the following options:
- Containing
- Beginning with
- Ending with
Top N elements tab
In this tab, you can list all elements with the extremely highest/lowest values – for example, the top 10 sales
documents by sales value. To run the “Top N” filter, go to the dimension’s filter pane:
select the second tab Top N elements and then the option Show top N elements:
When selected, additional filter definition options are activated:
- Show elements – used to define whether to filter the first or the last elements
- Element count – used to specify how many elements to include in the Top N filter
- Sort by – specifies the element by which to sort the filter results. In the example below, there are two
elements in the analysis: Sales measure and Document Number dimension.
Elements tab
The option Define element as expands the filter options with the following values:
- Perspective
Here you can specify the time range that will be dynamically updated each time the data model is refreshed.
For example, selecting This year will automatically select the range from the beginning of the year to the current
day each time the data model is recalculated during analysis.
- Time range
This option is used to specify the date range affecting the dimension in the form of a simple calendar.
Example:
- Date from
This option filters out all elements from a specified date.
- Date to
This option filters out all elements to a specified date.
- Exact date
This option filters a dimension to one date.
