Advanced Reporting with IBM Cognos Analytics

Learn via : Virtual Classroom / Online
Duration : 2 Days
  1. Home
  2. 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 

  • Definitions
  • 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