IBM Cognos 8 Advanced Report Studio Training Course Outline

Duration: 2 days

Audience: Advanced Professional Report Authors and Power Users

Brief:
This course is geared towards technical users who have a clear understanding of the information needs of the organization’s business users. These individuals will be responsible for the design and development of complex, highly formatted enterprise reports which will be distributed to business users.

Course Notes:
This course is delivered using a general IBM Cognos 8 demo application as the basis for the workshops, examples, and class discussion. If desired, custom courseware using client’s data may also be created. There is an additional fee for customization of the course materials.

Recommended Prerequisites:
IBM Cognos 8 Report Studio; IBM Cognos 8 Query Studio would be helpful, but not required. Familiarity with Windows, use of a web browser, and experience with the core MicroSoft Office suite of tools (Word, Excel, Access, etc) is desirable.

Training materials are copyrighted proprietary materials owned exclusively by Applied Business Systems, Inc.

Topics:

Report Formatting, Layouts & Templates
• Report blocks
• Using tables
• Aligning objects within containers
• Object types; unlocking an object
• Adding report pages
• Hyperlinks
• Report layouts/displaying standard report
information
• Reusing objects
• List page headers and overall header
• Page sets

Drill-through and Bursting Reports
• Drill-through
• Distribute reports via E-Mail (Bursting)

Report Queries
• Essentials of report building
• Multiple queries
• Master-detail queries
• Viewing tabular data and SQL
• Advanced filters and calculations
• Slicers and prompts
• Miscellaneous objects used in Query Explorer

Specialized Reports
• Charts
• Maps
• Repeaters
• Financial reporting

Event Studio Overview & Process
• Adding tasks
• Executing rules
• Scheduling the agent

Advanced Reporting
• Shading
• Sort order using prompts
• Prompts to display report objects
• Conditional filtering
• Filter Based on Output Type
• Report specification XML
• Dimensional reporting (MDX functions)