Course duration
- 2 days
Course Benefits
- Review Reporting Techniques
- Create advanced reports in the Query Explorer
- Joins
- Unions
- Sub queries
- Burst reports
- Advanced Prompting
- Introduce Active Reports
- Create advanced reports
- Dashboards with Drill-Through
- Advanced Formatting
- Advanced Calculations
- Create reports with multidimensional data sources
Course Outline
- 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
- Complex report examples
- 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
Class Materials
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Experience in the following is required for this Cognos class:
- Experience with IBM Cognos Reporting.
Courses that can help you meet these prerequisites:
Instructor-led courses are offered via a live Web connection, at client sites throughout Europe, and at our Geneva Training Center.