Unit 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 models
Unit 2 : Create reports based on query relationships
- Create reports by joining queries
- Combine data containers based on relationships from different queries
Unit 3 : Create advanced dynamic reports
- Filter reports on session parameter values
- Navigate a briefing book using a table of contents
- Create dynamic headers and titles that reflect report data
- Create a customer invoice report
Unit 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
Unit 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
- Create a report with tabbed pages. - New
Unit 6 : Examine the report specification
- Examine the report specification structure
- Save and edit reports locally
- Discuss considerations for modifying a report specification
- Discuss adding custom toolbox objects and custom template options
Unit 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 the IBM Cognos Analytics portal
Unit 8 : Enhance user interaction with HTML
- Create tooltips that clarify report data
- Create a popup window that contains prompts
- Send emails using links in a report
Unit 9 - End-to-end workshop
- Report 1: Burst a sales report by country
- Report 2: Create a report letting users choose top and bottom number of product types
- Report 3: Let users choose a chart type to display with a crosstab
Appendix A - 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