Mindmajix

How to Filter before auto aggregation and after aggregation in cognos

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:

Screenshot_765

Screenshot_766

Screenshot_767

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.

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:

Screenshot_768

Screenshot_769


0 Responses on How to Filter before auto aggregation and after aggregation in cognos"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.