What is Group Filter in Cognos

Rating: 5.0Blog-star
Views: 3725
by Ravindra Savaram
Last modified: January 30th 2021

A filter limits the information Cognos will retrieve for your report.

In general, you should always filter your report to ensure that it contains exactly the information you need. Often, you will want need many filters. Information must match all filters for it to appear on your report.

Enroll for Instructor Led Live Cognos Training Online

Group Filter:

Group Filter: Applies a filter to groups in the report. Generally appears in the query of query explorer.

You can filter information at a higher level by using the Group Filters tab in the Filters window. When you apply a group filter to a report item say, Product type, product types that do not fit your specification are filtered out when you run the report.

  • A filter which applies to the group is known as group filter
  • Add the following items to the list
  • Product line
  • Product type
  • Quantity
  • Define group on Product line
  • Define total on quantity
  • From the menu bar, select data
  • Select filters
  • Select the edit filters
  • Select summary filter
  • Click on add
  • Select the radio button Custom based on data item Quantity
  • Click on OK
  • Select the operator >
  • Type the value 100000
  • Click on OK
  • Run the report
  • In the report, we can see Golf Equipment Total 99400
  • Now select Edit filters
  • Select Summary Filter
  • Select the scope value as Product line
  • Click on OK
  • Run the report
  • Now in the report, we can not see Golf Equipment
Explore Cognos Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

Group Filter:


Frequently Asked Cognos Interview Questions & Answers



Be the first to catch the latest happenings of technology with us.

About Author

NameRavindra Savaram
Author Bio


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.