Filters are used to emphasize the important information and filter out what is unnecessary. You can apply a filter to a report to change the focus of the report.
Detail filter:-
- Detail filter is used to filter detail-level data within a report. A detail filter applies one or more specified conditions to each row of data. If conditions are true for a row, data in the row is retrieved and appears in the report. If a condition is not true, then row is not retrieved and it is not retrieved in the report.
- Detail filters can apply to each and every record in the database.
- Detail filter comes under the where clause.
- In detail filter you have two options while using it:
Before auto aggregation or after auto aggregation i.e. before the data is brought into the cache or after the data has been brought into the cache.
If you add set the property as before auto aggregation filter will be applied to where clause otherwise filter is applied in having
Summary filter:
- A summary filter is used to filter summary-level data in a report. Before you create a summary filter, you must calculate the summary level data items that you want to use in the filter.
- A summary filter can apply to summary level data.
- Summary filter comes under having clause.
- Summary filters don't have the option before auto-aggregation or after aggregation.
