BI Tool Filters

 

The Filters screen is an option from the Data Sources screen (see BI Tool Data Sources).

 

A screenshot of a data source

Description automatically generated

Figure 62: Data Sources > click menu button to access Filters

 

The Filters option will allow you to set up default filter(s) on the fields chosen. There are two types of filters in the BI Tool:

§ Source Filter - Type in the condition in the SQL query. Verify can check the syntax and Clear removes current filters in the Source Filter.

§ Report Filter - User can select the column and condition to create a filter for the report being created or in use.

Graphical user interface, application, table

Description automatically generated

Figure 63: Filters screen

 

In Grid view, the report viewer can set or change filters that are set up in Report Filter. The Source filter is invisible in grid view and only users who have edit permissions can change it.