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
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)
- describe the Prompt API
- describe the uses of the Prompt API
- describe the primary objects, methods and properties used in the Prompt API
- review prompt values
- explore the enhancement of prompts in reports with the Prompt API
