Filters and its types in Cognos

Ratings:
(4)
Views:0
Banner-Img
  • Share this blog:

 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

You liked the article?

Like : 0

Vote for difficulty

Current difficulty (Avg): Medium

Recommended Courses

1/15

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 in the market.