Description

Cognos 10 BI Query Studio is a tool dedicated to creating simple reports. Easy to use, Query Studio allows you to create ad hoc reports, based on specific needs. At the end of this internship, you will know how to quickly query and extract Cognos data and produce your own reports.

Who is this training for ?

For whom ?

This course is aimed at users and IT professionals wishing to define simple reports such as a list, a crosstab or a graph.

Prerequisites

Training objectives

Navigate the Cognos Connection portal

Create a report based on one or more selection criteria

Refine and present the analysis well with graphs, prompts and filters

Enrich the formatting of the different elements of a report

Use the different report execution and distribution modes

Training program

• Cognos Connection
  • Discover the Cognos Connection portal.
  • Set preferences.
  • Display, working language, etc.
  • Study the Cognos Connection objects.
  • Customize Cognos Connection.
  • Hands-on Discover the portal and connect to it.
  • Change the display and working language.
  • Create a new folder to save reports.
• Introduction to Query Studio
  • Discover Query Studio.
  • Getting started with the tool.
  • Open a report.
  • Insert data into a report.
  • Discover the different types of reports.
  • Practical work Restore data based on one or more criteria.
  • Add, move and group columns.
  • Sort on a column.
• Create reports in Query Studio
  • Create lists, grouped lists, and crosstabs.
  • View data in graphs.
  • Filter data.
  • Use prompts to define filter criteria.
  • Practical work Create an analysis report on certain dimensions.
  • Add columns.
  • Create a combined filter on several dimensions.
• Format Query studio reports
  • Format data.
  • Calculate and sort data.
  • Apply conditional formatting.
  • Apply a template.
  • Practical work Create a TOP 10 best values ​​report.
• Edit and navigate Query Studio reports
  • Run a report.
  • Discover the execution options.
  • Produce the report in HTML, PDF and CSV.
  • Create custom report views.
  • Manipulate dimensional data.
  • Hands-on Create a report view and report output.
  • Extract data in report versions in English/French and HTML/PDF.
• Administer reports in Cognos
  • View report execution history.
  • Save a report to a public folder.
  • Deliver reports by email.
  • Print reports.
  • Schedule reports.
  • Hands-on Create and schedule multiple reports to run.
  • Schedule its execution at a given frequency.