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.

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

Goals
  1. Review Reporting Techniques
  2. Create advanced reports in the Query Explorer
    1. Joins
    2. Unions
    3. Sub queries
  3. Burst reports
  4. Advanced Prompting
  5. Introduce Active Reports
  6. Create advanced reports
    1. Dashboards with Drill-Through
    2. Advanced Formatting
    3. Advanced Calculations
  7. Create reports with multidimensional data sources
Outline
  1. Review of IBM Cognos Analytics & Reporting
    1. Review of IBM Cognos Analytics
    2. Review of Reporting Techniques
  2. Introduction to the Query Explorer
    1. Query Components
    2. Build and modify queries from the Query Explorer
    3. Create union and join queries
    4. Create queries with SQL
    5. Create child queries
  3. Introduction to Bursting
    1. Definitions
    2. Create a bursted report
  4. Advanced Prompting
    1. Review of prompts
    2. Prompts with static values
    3. Prompts that perform sorting
    4. Conditional formatting with prompts
  5. Introduction to Active Reports
    1. Understand Active Reports
    2. Create a simple active report
    3. Create an active report with a chart
  6. Advanced Reporting
    1. Complex report examples
      1. Advanced Drill Through
      2. Complex calculations
      3. Table of Contents
      4. Dynamic time periods
  7. Working with Dimensional Models
    1. MDX and Unique Member Names
    2. Work with context filters and member sets
    3. Work with Dimensional functions
    4. Period to Date calculations
    5. Tree Prompts
  8. HTML Items (Appendix)
    1. Basic HTML in Reporting
  9. Import and Export XML Reports (Appendix)
    1. View and understand the report specification
    2. Import XML report specifications
    3. Export XML report specifications
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this Cognos class:

  • Experience with IBM Cognos Reporting.
Prerequisite Courses

Courses that can help you meet these prerequisites:

Preparing for Class

Training for your Team

Length: 2 Days
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

What people say about our training

I would recommend this course for any company.
Mary Steffan
Lumiere Laser & Vein Center
Terry is very thorough in the subject matter and was able to explain exceptionally well how to use SQL and SQL expressions, which were of particular interest to me.
Debbie Zweifel-Yaciuk
NERA Economic Consulting
The instructor was informative, patient and truly taught the class where I feel I can use PowerPoint and even as a beginner.
Jasmine Borrego
TELACU Residential Management
I am amazed at all the things that Excel is capable of. I learned a lot of things that will help make my work day easier.
Gillian Gibbs
Methodist Hospital for Surgery

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

60,864

Students who have taken Instructor-led Training

11,703

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.29

Students rated our trainers 9.29 out of 10 based on 28,812 reviews

Contact Us or call 1-877-932-8228