Cognos tutorias

  Filter: It is nothing but a condition to restrict the data to be displayed on the report There are two types of filters Model filter 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 Stand alone filter 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 Static filter 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: cou