Add a filter expression to focus a report and minimize processing time by excluding unwanted data.
Filter before aggregation:
If the filter is applied before an aggregation, then non aggregated records (Detail records, applies a filter to individual row’s data.) are filtered.
Detail filters are applied to the data source. They are boolean expressions used to exclude database rows based on non-aggregated values or to exclude lower level groups based on leaf aggregates.
Detail filter is applied to the whole body of the report.
Procedure:
Add the following items to the list container
Product line
Product type
Quantity
Define group on the product line
Define total on quantity
Select quantity data item
From menu bar, select data
Select filters
In the operator list box, select >
In the value text box, type 75000 and Click on OK
From menu bar select data
Select filters
Select Edit filters
Select Detail filters
Select Filter before auto aggregation radio button
Save and run the report
Filter Before Aggregation:
Filter after aggregation:
If the filter is applied after an aggregation, then (Summary records) are filtered.
Summary filters are boolean expressions, used to exclude specific groups based on the group aggregates. They are based on summary calculations.
Frequently Asked Cognos Interview Questions & Answers
Summary filter is applied to only at footer level.
Add the following items to the list container
Product line
Product type
Quantity
Define group on the product line
Define total on quantity
Select quantity data item
From menu bar, select data
Select filters
Select custom filter
In the operator list box, select >
In the value text box, type 50000 and Click on OK
From menu bar select data
Select filters
Select Edit filters
Select Detail filters
Select Filter after auto aggregation radio button
Save and run the report
Filter After Aggregation:
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
Name | Dates | |
---|---|---|
IBM Cognos Training | Jun 10 to Jun 25 | |
IBM Cognos Training | Jun 13 to Jun 28 | |
IBM Cognos Training | Jun 17 to Jul 02 | |
IBM Cognos Training | Jun 20 to Jul 05 |
Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.
1 /15
Copyright © 2013 - 2023 MindMajix Technologies