Description

This course will teach you how to use the different functions of Cognos 10 BI Report Studio. It is aimed at advanced users and IT professionals wishing to define simple or more elaborate reports based on relational and dimensional packages.

Who is this training for ?

For whom ?

Advanced users of the solution and IT professionals.

Prerequisites

Training objectives

Select and sort data to be rendered according to different criteria

Improve the presentation of data by grouping it and adding calculations

Use the graphical representations offered by Cognos Report Studio

Add advanced objects in a report and format them

Use filters and prompts to drill down into a report

Training program

• Introduction to Report Studio
  • Discover Report Studio and its interface.
  • Study the different types of reports.
  • Create a simple, sorted and formatted report.
  • Practical work Create a list type report.
  • Select data according to several criteria.
• Create and format simple reports
  • Group data.
  • Apply grouping level scope and sort criteria.
  • Add totals for each data group.
  • Create list headers and title blocks.
  • Practical work Create groupings and sections.
  • Create intermediate subtotals.
• Review other report types
  • Create a crosstab.
  • Create a chart.
  • Create a repeater.
  • Enable drill-down and drill-down features 'access to detail.
  • Practical work Create a circular type graph to analyze facts according to several dimensions of analysis.
  • Change the type of graphic representation.
  • Run a report in HTML format.
• Filter data
  • Create filters.
  • Know when to apply filters.
  • Define filter properties and types.
  • Create drill-through to another report.
  • Practical work Extract data on a range of specific dimension values.
• Create and use prompts
  • Learn how to use parameters and prompts.
  • Learn about prompt types.
  • Navigate between pages with the Page Explorer.
  • Hands-on Create a report with cascading prompts to analyze specific values.
  • Create prompt pages by type of criteria to choose.
  • Ensure automatic submission.
• Perfect reports
  • Use insertable objects such as table, block and text.
  • View object placements.
  • Add page headers and title blocks.
  • Examine report expressions.
  • Format report data and objects.
  • Add calculations.
  • Add pages and sets of pages.
  • Master/detail report and multi-query management.
  • Set Report Studio report burst publishing options.
  • Practical work rnCreate a multi-query report combining multiple display types.
  • Add formatting objects to improve readability.