mobileNavlogo
headerlogo

Blog

Filters and its types in Cognos

21 September, 2018

Related Blogs

 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 arrrowcreatearrrow filter arrrowname country (?) expand country_multilingual arrrow drag on the country on expression definition window arrrowok
 

Procedure  to create a folder under the namespace:

  • Right click on the “namespace” arrrow create folder
  • Folder namearrrow filterarrrow 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 --> rightclickarrrow select edit definitionarrrow select filter tabarrrow click on addarrrow filter  name  language_enarrrowexpression definition = ’EN’arrrowokarrrow select test tabarrrow click test sample arrrow ok For indepth understanding Cognos Training click on
About Author
Authorlogo
Name

TekSlate

Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .