Cognos Professional Report Authoring

Advanced 2 days


In this course you will learn to

  • Create advanced list, chart and map reports
  • Develop advanced drill-through reports
  • Build reports with advanced conditional formatting
  • Design effective prompts
  • Get started with the query model
  • Use dimensional authoring techniques
  • Use standard templates to design complex reports
  • Consolidate reports with table of contents and bookmarks
  • Use conditional statements and parameters
  • Use layout component reference objects
  • Use query macros for report-level security


11.x (v10 available for private training)

Included in this course

  • Hands-on exercises
  • Course manual

Suggested attendees

Experienced enterprise report authors and technical business analysts. Required: beginning/intermediate class or report development experience.

New Features for Experienced Authors is best for those with significant experience with Report Studio authoring.

Choose Format


Course Outline

  • Advanced list reports
    • Deconstruct the list object
    • Create headers, footers and custom group summaries
  • Advanced authoring using chart reports
    • Create chart reports
    • Understand nested and peer chart items
    • Examine advanced chart properties
  • Prompts and parameters
    • Review simple prompts using filtered parameters
    • Examine prompt types
    • Create a cascading prompt
    • Create a self-drilling report that handles no data
  • Advanced conditional formatting
    • Compare conditional formatting to advanced conditional formatting
    • Examine conditionally formatted reports
    • Create advanced exception reports
    • Conditionally hide or show report objects
  • Dimensional authoring fundamentals
    • Discuss data sources
    • Review a dimensional query
    • Discuss report authoring styles
  • Advanced queries
    • Examine filtering data from two separate queries
    • Join queries
    • Create set operations (unions, intersects and exceptions)
  • Best practices for design
    • Create reports using templates
    • Effectively use tables and blocks
    • Organize report layouts into bands of information
    • Examine visual aids
    • Add page headers and footer
  • Free-form reports
    • Use standard templates as a basis for complex reports
    • Create layout component references to re-use objects
    • Define reports to be used as templates
  • Advanced expressions
    • Create reports with advanced expressions
    • Use query macros and session parameter
  • Prompt macros, advanced use of parameters and report-level security
    • Use basic parameters to drive report layout and data behavior
    • Examine prompt macros
    • Restrict access to data based on user attributes
  • Create consolidated reports
    • Discuss briefing books