IBM Cognos Analytics - Author Reports Advanced (v11.0)

1: 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

2: Unit 2 Create reports based on query relationships

• create reports by joining queries

• combine data containers based on relationships from different queries

3: 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

4: 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

5: 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

6: 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

7: 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

8: 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

9: 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