home 
 
 
 
ennl
 
Home
A propos
Services
Cours
Ressources
Contacts
MyABIS
Tous les coursbalkjeGénéralités » Introduction HW & SW » Cycles completsSystèmes d’exploitation » MVS - z/OS » UNIX - Linux - AIX » VMwareBases de données, systèmes transactionnels et middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Business intelligence et data warehouseDéveloppement d’applications » Méthodiques et techniques » TOGAF » PRINCE2 » Les langages de programmation » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesGestion de système » ITILbalkjeEn pratiqueInscriptions 
Cette page n'est pas disponible en français.
Cognos BI Connection & Query Studio

Intended for

This course is intended for end users of the IBM Cognos Connection web portal and Query Studio, using the tool as an ad-hoc query tool and for creating simple reports.

Background

There are no specific prerequisites for Connection & Query Studio, basic awareness of IBM Cognos would be desirable.

Training method

Connection & Query Studio is a hands-on course that illustrates the key concepts of IBM Cognos Connection and Query Studio while learning how to use the tool.

Course leader

Numius.

Duration

1.5 days.

Schedule

datelanguelieuprixremarques
26/03/2012 Louvain870 EUR
15/05/2012NWoerden870 EUR
24/05/2012ELouvain870 EUR
Légende
  • Vous pouvez vous inscrire en cliquant sur les dates dans le calendrier.
  • N: Néerlandais; F: Français; E: Anglais; Sans code de langue: dépendant des participants.
  • Tous les prix sont hors TVA.
  • Pays:
    Belgique 
    Pays-Bas 
    Ailleurs 

Objectives

IBM Cognos BI Connection & Query Studio is a 1.5 day, instructor-led course during which attendees are taught how to manage content in the Cognos Connection Web portal and how to create, modify and organize simple ad hoc reports using Query Studio.

This course applies to both Cognos version 8 and Cognos version 10: the course will be based on one version, but differences will be pointed out when neccessary.

Main topics

  • IBM Cognos BI Connection

Attendees will learn how to access reports, run a report with options, schedule a report to run at a specific time with specific output and language formats, and create report views in the Cognos Connection Web portal. In addition, the course will teach you how to personalize the appearance of Cognos Connection by changing personal settings and creating folders to organize content.

  • List view
  • Details view
  • Navigate
  • Preferences
  • Create a folder
  • Create a job
  • Add a URL
  • Create a page
  • Set properties
  • Change order
  • Run a report
  • View a report
  • Screen
  • Items on checklist
  • Open reports in a studio
  • Open studios
  • IBM Cognos BI Query Studio

This part of the course covers how to use different report capabilities, how to graphically display the data, and how to create reports with a consistent look and feel through the use of templates. The course also covers basic administrative tasks, such as scheduling reports and delivering reports in different formats (HTML, PDF, Excel, etc.).

  • Introduction
  • Query items
  • Understand how reports are structured
  • Selecting fields
  • Drag fields
  • Suppressing
  • Auto group
  • Turn off auto group
  • Footers
  • Define custom groups
  • Create a crosstab report
  • Sorting
  • Calculations
  • Change report layout
  • Change border styles
  • Change the number of rows shown per page
  • Edit title area
  • Generate footer summaries for measures
  • Define conditional styles
  • Apply template
  • Add a chart
  • Report run modes
  • Filters
  • Standard filter on date field
  • Standard filter on numeric field
  • Standard filter on text field
  • Remove filter
  • Predefined filter
  • Negative filter
  • Combine filters
  • Report in Report Studio