IBM Cognos Report Studio: Author Professional Reports Fundamentals Training

• Familiar with IBM Cognos BI components, architecture, groups, and roles
• Understand Report Studio, its interface, and different ways of creating reports
• Create reports using filters, applying different functions for sorting, grouping, and managing repeated data
• Create charts for representing data graphically
• Work with various prompt types to focus data and navigate between pages
• Use additional report building techniques for using the objects within the same report and sharing components among different reports
• Customize reports and enhance report layout for different queries and different print options
• Work on Drill-through process

The professional report authors with the skills outlined below can be ideal participants for this course:

• Knowledge of their business requirements
• Knowledge of SQL and XML
• Completed IBM Cognos BI for Consumers (10.2) course

1. Overview of IBM Cognos BI

• Describe IBM Cognos BI and Financial Performance Management
• Describe IBM Cognos BI components
• Describe IBM Cognos BI architecture at a high level
• Define IBM Cognos  groups and roles
• Explain how to extend IBM Cognos

2. Introduction to the Reporting Application

• Examine Report Studio and its interface
• Explore different report types
• Create a simple, sorted, and formatted report
• Explore how data items are added to queries

3. Create List Reports

• Format, group, and sort list reports
• Describe options for aggregating data
• Create a multi-fact query
• Create a report with repeated data

4. Focus Reports Using Filters

• Create filters to narrow the focus of reports
• Examine detail and summary filters
• Determine when to apply filters on aggregate data

5. Create Crosstab Reports

• Format and sort crosstab reports
• Convert a list to a crosstab
• Create crosstabs using unrelated data items
• Create complex crosstabs using drag and drop functionality

6. Present Data Graphically

• Create charts containing peer and nested items
• Add context to charts
• Create and reuse custom chart palettes
• Present key data in a single dashboard report

7. Focus Reports Using Prompts

• Identify various prompt types
• Use parameters and prompts to focus data
• Search for prompt items
• Customize prompts to facilitate users' choices
• Navigate between pages
• Display users' prompt selections in the report

8. Extend Reports Using Calculations

• Create calculations based on data in the data source
• Add run-time information to the reports
• Create expressions using functions

9. Present Data Using Maps

• Present data using map reports
• Navigate to another level within a map

10. Use Additional Report Building Techniques

• Reuse objects within the same report
• Share layout components among separate reports
• Discuss report templates
• Add pages to a report
• Choose options to handle reports with no available data

11. Customize Reports with Conditional Formatting

• Create multi-lingual reports
• Highlight exceptional data
• Show and hide data
• Conditionally render objects in reports

12. Drill-Through From One Report to Another

• Let users navigate from a specific report to a target report
• Pass parameter values to filter the data in drill-through targets

13. Drill-through Definitions

• Enable users to navigate to related data in IBM Cognos BI
• Parameter-driven drill through vs. dynamic drill through
• Steps to enable drill-through access for a package
• Limit the items that users ca drill through from (set scope)
• Set a measure as the scope
• Drill Through Assistant

14. Enhance Report Layout

• Force page breaks in reports
• Modify existing report structures
• Apply horizontal formatting
• Specify print options for PDF reports
• Combine data containers displaying data from different queries
• Format data and report objects