Blog

  • Home
  • Cognos
  • Creating static and parameterized filters in Cognos

Creating static and parameterized filters in Cognos

  • (4.0)
  • | 1430 Ratings

Model Filters:

  • A filter is a restriction that reduces the no. of records returned from the database
  • A condition is created with three elements
  • Query item, Operator, Operand
  • Model filters are reusable
  • Model filters are categorized into 2 types

          a) Static model filters
          b) Parameterized model filters

In this section, let us have a quick glance about Static model filters, as well as about parameterized model filters.

Enroll for LIVE Instructor LED ONLINE COGNOS TRAINING

Creating static and parameterized filters in Cognos

Static Filters:

  • From project viewer pane
  • Select the MODEL
  • Right click
  • Select Create
  • Click on Filter
  • Enter the name ORDER METHOD
  • From left pane
  • Expand MODEL
  • Double click on the query item order_method_en
  • Type the operator in
  • Type the operands as (‘web’,’telephone’)
  • Click on OK

Testing Filters:

  • From MODEL
  • Expand the SALES namespace
  • Select order_method query subject
  • Right click
  • Click on Edit definition
  • Select the filter
  • Drag the filter to the filters window
  • Select the test tab
  • Click on test sample
  • From filters table
  • Clear the filter
  • Click on OK

Static Testing filter 1Static Testing filter 2

Static Testing filter 3Static Testing filter 4Static Testing filter 5Static Testing filter 6Static Testing filter 7Static Testing filter 8Static Testing filter 9

Parameterized filters:

  • A parameterized filter lets the user/prompts the user to select the value/enter the value to restrict the data returned from the database
  • A parameterized filter is also known as prompt/dynamic filter
  • Prompt lets the user to select the value at query runtime
  • A prompt is a user interactive object

Syntax:

Query item      operator      ?parameter?

Order_method      in      ?ord?

HTTP://BIT.LY/1OA0ZN2

Frequently Asked Cognos Interview Questions & Answers


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