IBM Cognos Report Studio: Author Professional Reports Advanced Training

• Build query model, add filters and prompts to author and customize reports
• Create reports by applying relationship on the queries and applying dynamic headers
• Display reports in the customized format focusing on summarized report information
• Examine the report specification structure and add custom template options
• Distribute reports using bursting, email, and IBM Cognos Connection
• Analyze Data Using Statistical Reports

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 Report Studio: Author Professional Reports Fundamentals (V10.2) course

1. Create Query Models

• Build query models and then connect them to the report layout
• Edit an SQL statement to author custom queries
• Add filters and prompts to a report using the query model

2. Create Query Reports Based on Relationships

• Create reports by merging query results
• Create reports by joining queries
• Combine data containers based on relationships from different queries

3. Create Advanced Dynamic Reports

• Filter reports on session parameter values
• Navigate a briefing book using a table of contents
• Create dynamic headers and title that reflect report data
• Let users navigate to specific locations in reports
• Create a customer invoice report

4. Design Effective Prompts

• Control report displays using prompts
• Specify conditional formatting values using prompts
• Specify conditional rendering of objects based on prompt selection
• Create sorted and filtered reports based on prompt selection

5. Create Additional Advanced Reports

• Create a report that displays summarized data before detailed data
• Highlight alternate rows in a list report
• Create a report using an external data file
• Use single data items to summarize report information

6. Examine the Report Specification

• Examine the report specification structure
• Modify a report specification
• Add custom toolbox objects and custom template options

7. Distribute Reports Through Bursting

• Distribute reports using bursting
• Create burst keys
• Identify report recipients and data items using burst tables
• Distribute reports using email and IBM Cognos Connection

8. Enhance User Interaction with HTML

• Create tooltips that clarify report data
• Send emails using links in a report

9. Analyze Data Using Statistical Reports

• Discuss statistical report types
• Examine descriptive statistics
• Explore statistical charts

10. End-to-End Workshop (Optional)

• Various managers have requested that you create reports to answer business questions pertaining to their areas of interest

11. Explore the Prompt API (Optional)