Duration
2 days
Pre-requisites
You should have:
- Completed IBM Cognos Report Studio: Author Professional Reports Fundamentals (V10.2)
- Knowledge of your business requirements
- Basic knowledge of SQL
- Basic knowledge of XML (recommended)
Course Objective
Please refer to the Course Overview for description information.
Key topics
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
Programme scope, delivery arrangements and suitability are confirmed during enquiry.