A filter allows you to limit the kind of data you want retrieved for your report. For example, you may want to create a filter to limit your report to information for only a specific department, or a specific profit center, or a data range.
You can have one or many filters in a report query – when you run the report, Cognos returns only those records that agree with all filters.
Static Report filters:
Run immediately upon request, and then stored with the data in the Completed Reports module.
Group Span: When columns are grouped, you can choose how often to show column names by changing the group spanning. For example, when country and city are both grouped, you can choose to show the country name each time
It eliminates the duplicates for the columns having one to one relationship
Add the following items to the list
Types of query items:
A query item is the smallest object in the model that can be placed in a report. It represents a single instance of something, such as the date that a product was introduced.
In a business model the query items are categorized into three types
1) Identifiers: A query item with the type KEY, INDEX, DATE and
The TIME data type is used as identifiers
Ex: Product_no, customer_id, order_date
2) Attributes: A query item with the type ‘ STRING ‘ data type and descriptions are known as attributes
Ex: Product name, Country name, Customer name, Product Description
3) Facts: A query item with the type numeric and key performance indicators are known as FACTS
Ex: Quantity sold, Revenue
Regular Aggregation: The default aggregation for the query item with the type
FACT is SUM
Filter on attributes:
FILTER ON ATTRIBUTES:
Get Updates on Tech posts, Interview & Certification questions and training schedules