• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

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 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

“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 info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Filters and its types in Cognos"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.