- Learning Objectives - This module is a deep-dive into report authoring, linking two reports and displaying one report layer based on others using prompts? You will be given an opportunity to use union, intersection and join operations. You will acquire knowledge on how to distribute one report contents to various recipients.
Introduction to the Reporting Application
- Examine Report Studio and its interface
- Explore different report types
- Create a simple, sorted, and formatted report
- Explore how data items are added to queries
Create List Reports
- Group, format, and sort list reports
- Describe options for aggregating data
- Create a multi-fact query
- Create a report with repeated data
Focus Reports Using Filters
- Create filters to narrow the focus of reports
- Examine detail and summary filters
- Determine when to apply filters on aggregate data
Create Cross Tab Reports
- Format and sort crosstab reports
- Create complex crosstabs using drag and drop functionality
- Create crosstabs using unrelated data items
Present Data Graphically
- Create charts containing peer and nested columns
- Present data using new chart type options
- Add context to charts
- Present key data in a single dashboard report
Focus Reports Using Prompts
- Identify various prompt types
- Use parameters and prompts to focus data
Extend Reports Using Calculations
- Create calculations based on data in the data source
- Add run-time information to the reports
- Create expressions using functions
Design Effective Reports
- Enhance report design with report objects
- Reuse objects within the same report
- Share layout components among separate reports
Customize Reports With Conditional Forming
- Create multi-lingual reports
- Highlight exceptional data
- Show and hide data
- Conditionally render objects in reports
Drill-Through from One Report to Another
- Let users navigate from a specific report to a target report
- Pass parameter values to filter the data in drill-through targets
- Navigate through multiple reports
Examine the Report Specification
- Examine the report specification structure
- Save and edit reports locally
- Discuss considerations for modifying a report specification
Create Reports Based on Query Relationships
- Create reports by merging query results
- Create reports by joining queries
- Combine data containers based on relationships from different queries
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
Active Reports
- Active Reports Introduction
- Create active report templates
- Describe active report connections, Apply Filter and Select behavior to active report controls
- Identify active report controls and variables in a report
- Use variables to control multiple controls independently
- Describe characteristics of traditional charts inactive reports
- Control data display using decks and data decks
