Blog

  • Home
  • Cognos
  • Dynamically Selecting Filters Before Auto Aggregation & After Aggregation in Cognos

Dynamically Selecting Filters Before Auto Aggregation & After Aggregation in Cognos

  • (5.0)
  • | 3598 Ratings

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

Filter Before Aggregation:

Before aggressionIBM Cognos desktopdesktop 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 aggregationfilter after aggregation 2

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

Subscribe For Free Demo

Free Demo for Corporate & Online Trainings.

Ravindra Savaram
About The Author

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.


DMCA.com Protection Status

Close
Close