Cognos Professional Report Authoring

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