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
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
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
For indepth understanding Cognos Training click on
“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at email@example.com, we will update the article in 24 hours.”