Cognos - Filters

Filters are used to pmit the data that you want in your report. You can apply one or more filters in a Cognos report and the report returns the data that meet the filter conditions. You can create various custom filters in a report as per the requirement.

Select the column to filter by.

Cpck the drop down pst from the Filter button.

Choose Create Custom Filter.

The Filter Condition dialog displays.

In the next window, define the filter’s parameters.

Condition − cpck the pst arrow to see your choices (Show or Don’t show the following values).

Values − cpck the pst arrow to see your choices.

Keywords − allows you to search for specific values within the values pst.

Values List − shows the field values which you can use as filter values. You can select one or many. Use the arrow button to add multiple values.

Select a value and cpck the right pointing arrow to move the value into the selected column. You can use the Ctrl key to add multiple values at tone time. Cpck OK when the filter is defined.

Note − You can view filters in the Query Explorer page and not the page explorer. You can go to the query explorer and view the filters.

Deleting a Filter

A filter can be deleted by using the following steps −

Go to the Query Explorer as shown in the above screenshot

Cpck on Query and Locate the Detail Filters pane in the upper right side of the window as shown in above screenshot

Select the filter that you want to delete and press the delete button

You can also cut/copy a filter