home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - OS/390 - z/OS » UNIX - Linux - AIX » Windows » VMwareDatabases, transaction systems and 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 and data warehouseApplication development » Methods and techniques » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical informationRegistration 
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

datelanguageplacepriceremarks
02/09/2010 Leuven850 EUR
23/09/2010NWoerden850 EUR
Legend
  • You can enrol by clicking on the dates in the calendar.
  • N: Dutch; F: French; E: English; No code: language depends on the participants.
  • All prices are VAT excluded.
  • Countries:
    Belgium 
    Netherlands 
    Elsewhere 

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.

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