Advanced Reporting with IBM Cognos Analytics

This Advanced Reporting with IBM Cognos Analytics training class provides advanced techniques with IBM Cognos' Reporting. Topics include the Query Explorer, bursting reports, advanced prompting, drill- through definitions, active reports, working with dimensional data and more. The course format includes lecture, instructor-led exercises and independent workshops.

Delegates will learn how to

  • Review Reporting Techniques
  • Create advanced reports in the Query Explorer
  • Burst reports
  • Advanced Prompting
  • Introduce Active Reports
  • Create advanced reports
  • Create reports with multidimensional data sources


The audience for this course includes report authors and developers who will create and maintain complex reports in reporting.

Review of IBM Cognos Analytics & Reporting 

Review of IBM Cognos Analytics

Review of Reporting Techniques


Introduction to the Query Explorer 

Query Components

Build and modify queries from the Query Explorer

Create union and join queries

Create queries with SQL

Create child queries


Introduction to Bursting 


Create a bursted report


Advanced Prompting 

Review of prompts

Prompts with static values

Prompts that perform sorting

Conditional formatting with prompts


Introduction to Active Reports 

Understand Active Reports 

Create a simple active report

Create an active report with a chart


Advanced Reporting 

Complex report examples 

Advanced Drill Through

Complex calculations

Table of Contents

Dynamic time periods


Working with Dimensional Models 

MDX and Unique Member Names

Work with context filters and member sets

Work with Dimensional functions

Period to Date calculations

Tree Prompts


HTML Items (Appendix) 

Basic HTML in Reporting


Import and Export XML Reports (Appendix) 

View and understand the report specification 

Import XML report specifications

Export XML report specifications

Introduction to Reporting in Cognos Analytics

Program Details
Duration 2 Days
Capacity Max 12 Persons
Training Type Classroom / Virtual Classroom

Can't find what you're looking for? Let us know if you have a query or cannot find what you are looking for.