The Filters screen is an option from the Data Sources screen (see BI Tool Data Sources).
Figure 65: 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.
Figure 66: 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.