Cognos 8 BI

1
Enhance Reports in Query Studio
Cognos 8 BI
2
Objectives

• In this module, we will
• highlight report items using conditional styles
• focus the scope of a report using filters
• format report objects
• apply a report template

3
Highlight Report Items using Conditional Styles

• You can define conditional styles to highlight
  key information in a report.

4
Demo 1

• Use Conditional Formatting
• Filter and Calculate Data in an Ad Hoc Report

5
Filter Data in Ad Hoc Reports

• Create a filter to retrieve a subset of records
  in a report.
• Any data that does not meet the criteria of the
  filter is eliminated from the report.

Original report
Filter on district
Filtered report
6
Filter Data Based on Report Details

• You can filter the values that appear in the
  detail rows of your report. This filtering
  eliminates detail rows that do not meet the
  specified criteria.

District Detail rows with Student Counts between
50,000 and 120,000 are displayed in the filtered
report.
7
Filter Data Based on Group Summaries

• You can filter on values in the footers of your
  ad hoc report. This filtering eliminates groups
  from your report that do not meet the specified
  criteria.

If the District Name summary is less than 2,000
or greater than 2,000 then all the detail rows
for that district line are displayed in the
filtered report.
8
Filter Data Based on Individual Records

• You can use a filter based on individual records
  in the underlying data source, even if the report
  contains only aggregated data.

Original report
Records in the data source that have quantities
of 50 or more are summed.
Data source
Filtered report
9
Specify Filter Criteria with Prompts

• Create a prompt if you want to use different
  criteria for the same report item each time the
  report is run.
• Using prompts is faster and easier than
  repeatedly changing the filter.

10
Use Advanced Filters

• You can combine two or more filters to do more
  complex filtering in your reports using AND/OR
  conditions.

11
Demo 2

• Use a Prompt to Filter Data

12
Demo 3

• Combine Filters

13
Specify Advanced Options

• When you run a report, you can change the way the
  data is processed by automatically
• summarizing measures in the footer
• summarizing detail values and suppressing
  duplicates

We are not summarizing detail values. Each sale
of every product is shown in the report.
14
Format a Report
Format a percentage column with decimal places
and negative signs.

• The formatting options available to you depend on
  the type of data you want to format.
• You can format text, numbers, currency,
  percentages, scientific expressions, date and
  time.

Format text with font, size, weight, style and
alignment.
15
Apply a Report Template

• You can apply a template to your report pages and
  prompt pages to give them the same look.

16
Summary

• In this module, we have
• highlighted report items using conditional styles
• focused the scope of a report using filters
• formatted report objects
• applied a report template