1. What are the differences
between a summary filter and a detail filter?
Detail filter:
When you use a detail filter to filter a report only on
detail data items, none of the data items in a detail filter are summary data
items. Examples of detail data items are product, order number, and customer
name. You can filter detail data items that you select from a query or a
catalog. A detail filter applies one or more specified conditions to each row
of data. If the conditions are true for a row, the row is retrieved and appears
in the report; if the conditions are not true, the row is not retrieved and
does not appear in the report.
While creating detail filter in Cognos Report Studio, there
are two options as Before auto aggregation and After auto aggregation.
§ Before
auto aggregation:
This will apply filter to individual records in the data source. This will filter records before Aggregation. This is default option selected for all reports
This will apply filter to individual records in the data source. This will filter records before Aggregation. This is default option selected for all reports
§ After
auto aggregation:
This will filter records after aggregation. This option needs to be selected when we want to apply aggregation and then filter content instead of filtering individual record like Rank Function.
This will filter records after aggregation. This option needs to be selected when we want to apply aggregation and then filter content instead of filtering individual record like Rank Function.
Summary filter:
A summary filter is used to filter summary data items in a report. Before you create a summary filter, you must calculate the summary data items that you want to use in the filter. Summary data items that you include in the filter are calculated before the filter is applied while summary data
items that aren't in the filter are calculated after the summary filter is applied. You can filter summary data items that you select from a report query or the catalog.
No comments:
Post a Comment