H4 – Advanced Report Authoring

Advanced report authoring techniques including complex queries, master-detail scenarios, aggregation, conditional formatting, output optimization, macros, bursting and embedding.

Chapters and lessons

H4-01 Working with queries

• H4-01-1 Filtering with subqueries
• H4-01-2 Queries using intersect and except operations
• H4-01-3 Queries with directly entered SQL

H4-02 Master-detail relationships

• H4-02-1 Master-detail relationships: tiles
• H4-02-2 Master-detail relationships: page sets

H4-03 Advanced calculations and aggregation

• H4-03-1 Filtering the first date
• H4-03-2 Subtotals
• H4-03-3 Moving average
• H4-03-4 Running total
• H4-03-5 New calculation functions: EXTRACT, LAG and LEAD

H4-04 Advanced conditional formatting with report variables

• H4-04-1 Alternating row backgrounds
• H4-04-2 Multilingual reports
• H4-04-3 String variables

H4-05 Special report design for PDF, Excel and HTML

• H4-05-1 Special report design for Excel
• H4-05-2 Special report design for PDF
• H4-05-3 Special report design for HTML

H4-06 Dynamic reports using Cognos macros

• H4-06-1 Dynamic data items using prompts
• H4-06-2 Dynamic data items using MUNs

H4-07 Bursting

• H4-07-1 Bursting with a single query
• H4-07-2 Bursting with recipient lists

H4-08 Tips and tricks

H4-09 Sharing, embedding and kiosk mode

• H4-09-1 Enhanced sharing features
• H4-09-2 Embedding Cognos content
• H4-09-3 Report auto-refresh and kiosk mode
• H4-09-4 Source and version control using GitHub/GitLab