Home  >  Blog  >   IBM Cognos

How to Create Parameterized Filters in Cognos

Rating: 5
  
 
5706

Brief on Parameterized Filters

Filter is nothing but a condition to restrict the data to be displayed on the report. A parameterized filter prompts the end user to select the value Or enter the value to restrict the data returned from the database.

A parameterized filter is known as PROMPT. Following are the various types of prompts.

1)  Text box prompt
2) Value prompt
3) Select & search prompt
4) Date prompt
5)  Time prompt
6) Date & time prompt
7)  Tree prompt
8) Generated prompt

Learn how to use Cognos, from beginner basics to advanced techniques, with online video tutorials taught by industry experts. Enroll for Free Cognos Training Demo!
  • A prompt creates based on the data type of a Query item, such prompts are called as generated prompts.

Design a list report with a basic parameterized filter:

  • Add the following query items to the list
  • Order number
  • Order date
  • Product name
  • Quantity
  • Revenue
  • Define the sort (ascending) on the order date query item
  • From menu bar, select Data
  • Select Filters
  • Select Edit filters
  • Select Detail filter
  • Click on
  • Click on Advanced Radio button
  • Double click on Order date
  • Provide the functions operators ≥
  • Type ?ord_date?
  • Click on OK
  • Click on OK
  • Save & Run the report

 MindMajix YouTube Channel

Design A List Report With A Basic Parameterized Filter

Parameterized Filter List report
Para meterized Filter 1
Parameterized Filter 2
Parameterized Filter 3
Parameterized Filter 4
Parameterized Filter 5
Parameterized Filter 6
Parameterized Filter 7
Parameterized Filter 8

Frequently Asked Cognos Interview Questions & Answers

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 TrainingFeb 27 to Mar 13View Details
IBM Cognos TrainingMar 02 to Mar 17View Details
IBM Cognos TrainingMar 05 to Mar 20View Details
IBM Cognos TrainingMar 09 to Mar 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