Filters and its types in Cognos

 Filter:

It is nothing but a condition to restrict the data to be displayed on the report There are two types of filters

1. Model filter
2. Report filter

Model filter:

If a filter is created at the time of designing model then it is called a model filter Model filters are reusable

Report filter:

A filter which is created at the time of generating the report is called a report filter Report filter is specific to that particular report only

• Again model filters are two types

1. Stand alone filter
2. Embedded filter

Stand alone filter:

• It is created at name space level it is available as a separate object in the model
• It can be applied for any query subject in the model
• Stand alone filters are two types

1. Static filter
2. Dynamic filter (or) parameterized filter (or) prompt

Static filter:

If a filter condition is created with a static value that can’t be changed at run time than it is called a static filter  

Syntax to create static filter:

Query time (column) operator operand. EX: year = 2010 EX: country in (‘India, ‘USA’) EX: year is not in (2009, 2011) EX: create a static filter for year 2008 at model filter Procedure: open framework, manager with replanted project

• From project viewer pan, select the namespace (model) right click --> create-->  filter--> create name year_2006--> expand product

Interested in mastering Cognos? Learn more about Cognos Tutorial in this blog post.

Testing a filter:

• Select product_fore caste query subject, right click, select edit definition
• Select filter stop drag the filter year_2006, drop on filters window
• Select test tab click on test sample

Parameterized filter:

If a filter condition is created with a parameter then it is called a parameterized filter (or) dynamic filter (or) prompts It allows the user either select the value(s) (or) to enter the time of execution

Syntax to create parameterized filter:

Query item operator, Parameter? EX: year =? param_year? Country in? param_country? Create a parameterize filter for country

• Right click on the name space create filter name country (?) expand country_multilingual  drag on the country on expression definition window ok

Procedure  to create a folder under the namespace:

• Right click on the “namespace”  create folder
• Folder name filter next
• Select the required objects (filter) and click on finish

Embedded filter:

• If a filter is created at query subject level than it is called an embedded filter
• The scope of this filter is for the particular query subject

Procedure to create embedded filter:

Select the query subject country_mnultilingual --> rightclick select edit definition select filter tab click on add filter  name  language_enexpression definition = ’EN’ok select test tab click test sample  ok