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

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

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

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

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

Examine the Report Specification

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

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

Enhance User Interaction with HTML

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

Analyze Data Using Statistical Reports

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

End-to-End Workshop (Optional)

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

Explore the Prompt API (Optional)