H3 – Report Authoring

Fundamentals and intermediate report authoring in IBM Cognos Analytics. The course covers lists, crosstabs, visualizations, filters, prompts, calculations, layout and multi-page reports.

Chapters and lessons

H3-01 Introduction

• H3-01-1 Interface and your first report
• H3-01-2 Adjusting automatic layout options
• H3-01-3 Interactive report mode

H3-02 List reports

• H3-02-1 Grouped list: product overview
• H3-02-2 Grouped list: product details

H3-03 Crosstabs

• H3-03-1 Simple crosstabs
• H3-03-2 Asymmetrically nested crosstabs
• H3-03-3 Crosstabs with multiple measures
• H3-03-4 Pivoting lists into crosstabs and tips

H3-04 Visualizations

• H3-04-1 Visualizations
• H3-04-2 Charts
• H3-04-3 Maps (Mapbox)
• H3-04-4 Dynamic highlighting: interactive brush
• H3-04-5 Data brushing
• H3-04-6 Master-detail relationships with new visualizations

H3-05 Filters

• H3-05-1 Simple filter functions
• H3-05-2 Detail filters
• H3-05-3 Measure filters before/after aggregation
• H3-05-4 Summary filters

H3-06 Prompts

• H3-06-1 Prompt parameters
• H3-06-2 Value prompt on a prompt page
• H3-06-3 Text prompt and search-and-select
• H3-06-4 Cascading prompts
• H3-06-5 Calendar prompt
• H3-06-6 Dynamically setting default values
• H3-06-7 Dynamic prepopulation of prompt parameters

H3-07 Calculations

• H3-07-1 Simple calculations
• H3-07-2 Date functions
• H3-07-3 Summaries and aggregates
• H3-07-4 IF THEN ELSE and CASE
• H3-07-5 Text/string functions: substring, position, upper, lower, trim and concatenation
• H3-07-6 Layout calculations

H3-08 Layout

• H3-08-1 Formatting basics: data formats, colors, inheritance, headers and footers
• H3-08-2 Aligning and positioning objects
• H3-08-3 Object sizes and layout components
• H3-08-4 Style classes and format painter

H3-09 Conditional formatting

• H3-09-1 Conditional formatting

H3-10 Managing queries

• H3-10-1 JOIN
• H3-10-2 UNION
• H3-10-3 UNION illustrated as a diagram
• H3-10-4 JOIN with cardinalities

H3-11 Drill-through

• H3-11-1 Drill-through

H3-12 Multi-page reports

• H3-12-1 Multi-page annual report: headers and footers
• H3-12-2 Multi-page annual report: tabs
• H3-12-3 Multi-page annual report: prompts
• H3-12-4 Multi-page annual report: cover page and overview
• H3-12-5 Multi-page annual report: PDF and table of contents
• H3-12-6 Multi-page annual report: details with page breaks
• H3-12-7 Multi-page annual report for a product

H3-13 Output formats and HTML reports

• H3-13-1 New copy functions in HTML reports
• H3-13-2 New CSV output options
• H3-13-3 New Markdown output format