Home  >  Blog  >   IBM Cognos

Dynamically Selecting Filters Before Auto Aggregation & After Aggregation in Cognos

Rating: 5
  
 
7648

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.

Enroll for Instructor Led Live IBM Cognos Training

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

MindMajix Youtube Channel

Filter Before Aggregation:

Before aggression
IBM Cognos desktop
desktop view

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:

filter after aggregation
filter after aggregation 2

Explore Cognos Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

 

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
IBM Cognos TrainingMar 30 to Apr 14View Details
IBM Cognos TrainingApr 02 to Apr 17View Details
IBM Cognos TrainingApr 06 to Apr 21View Details
IBM Cognos TrainingApr 09 to Apr 24View Details
Last updated: 04 Apr 2023
About Author

Ravindra Savaram is a Technical 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.

read more
Recommended Courses

1 / 15