IBM Cognos Query Studio: Build Ad Hoc Reports (V10.1/10.2)


IBM Cognos Query Studio: Build Ad Hoc Reports (V10.1/10.2)

Course ID: CLBI009

Course Overview

IBM Cognos Query Studio: Build Ad Hoc Reports (V10.1/10.2) is a one- day course designed for business authors who want to learn how to create, modify and organize ad hoc reports. This course covers how to use different report capabilities, how to graphically display 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 (e.g. HTML, PDF, Excel).

Please Note:

Screen captures and labs in this course are taken from the V10.1 of the product. However, the concepts, procedures, and tasks are all applicable to a V10.2 environment and are suitable for V10.2 user education.

Who need to Attend

This intermediate course is intended for business authors.


  • Knowledge of your business requirements
  • Experience using basic Windows and web functionality
  • Experience using a web browser

Course Content

[accordion id="faq"]
[accordion_item in="true" id_parent="faq" title="Overview of IBM Cognos BI"]

  • Discuss IBM Cognos and Performance Management
  • Describe IBM Cognos BI components
  • Describe IBM Cognos architecture at a high level
  • Define IBM Cognos BI groups and roles

[accordion_item in="false" id_parent="faq" title="Introduction to Query Studio"]

  • List the packages available for reporting
  • Understand report types
  • Add and save data to ad hoc reports
  • View data by using charts

[accordion_item in="false" id_parent="faq" title="Create Reports in Query Studio"]

  • Create list, grouped list, and crosstab reports
  • List the charts available and their appropriate use
  • Calculate and sort report data
  • Define a custom group to create your own report
  • Use shared dimensions to create multi-fact queries

[accordion_item in="false" id_parent="faq" title="Enhance Reports in Query Studio"]

  • Highlight report items using conditional styles
  • Focus the scope of a report using filters
  • Format report objects
  • Apply a report template

[accordion_item in="false" id_parent="faq" title="End to End Workshop"]

  • Create a grouped list report
  • Filter data based on revenue and order year
  • Add a prompt to view sales of selected sales representative
  • Format the report
  • Create a crosstab report
  • Add a chart to the crosstab report
  • Generate report outputs
    • [/accordion_item]
      [accordion_item in="false" id_parent="faq" title="IBM Cognos BI for Consumers"]

      • Schedule and manage reports
      • View lineage information
      • Add comments to saved output
      • Personalize and organize content
      • Set alerts and watch rules
      • Design a portal page and dashboard
      • Set permissions using IBM Cognos BI groups and roles


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>