IBM Cognos Analytics Author Reports Advanced v11.0.x B6159G

Report Authors

Create query models

• Build a query and connect it to a report

Answer a business question by referencing data in a separate query

Create reports based on query relationships

• Create join relationships between queries

• Combine data containers based on relationships from different queries

Create a report comparing the percentage of change

Introduction to dimensional reporting concepts

• Examine data sources and model types

• Describe the dimensional approach to queries

Apply report authoring styles

Introduction to dimensional data in reports

• Use members to create reports

• Identify sets and tuples in reports

Use query calculations and set definitions

Dimensional report context

• Examine dimensional report members

• Examine dimensional report measures

Use the default measure to create a summarized column in a report

Focus your dimensional data

• Focus your report by excluding members of a defined set

• Compare the use of the filter() function to a detail filter

Filter dimensional data using slicers

Calculations and dimensional functions

• Examine dimensional functions

• Show totals and exclude members

Create a percent of base calculation

Create advanced dynamic reports

• Use query macros

• Control report output using a query macro

• Create a dynamic growth report

Create a report that displays summary data before detailed data and uses singletons to summarize information

Design effective prompts

• Create a prompt that allows users to select conditional formatting values

• Create a prompt that provides users a choice between different filters

• Create a prompt to let users choose a column sort order

Create a prompt to let users select a display type

Examine the report specification

• Examine report specification flow

• Identify considerations when modifying report specifications

Customize reporting objects

Distribute reports

• Burst a report to email recipients by using a data item

• Burst a list report to the IBM Cognos Analytics portal by using a burst table

Burst a crosstab report to the IBM Cognos Analytics portal by using a burst table and a master detail relationship

Enhance user interaction with HTML

• Create interactive reports using HTML

• Include additional information with tooltips

Send emails using links in a report

Introduction to IBM Cognos Active Reports

• Examine Active Report controls and variables

• Create a simple Active Report using Static and Data-driven controls

• Change filtering and selection behavior in a report

Create interaction between multiple controls and variables

Active Report charts and decks

• Create an Active Report with a Data deck

• Optimize Active Reports

Create an Active Report with new visualizations

• Knowledge of your business requirements

• IBM Cognos Analytics for Consumers (v11.0) WBT or equivalent knowledge

IBM Cognos Analytics: Author Reports Fundamentals (v11.0.x) or equivalent knowledge

Create query models

• Build a query and connect it to a report

Answer a business question by referencing data in a separate query

Create reports based on query relationships

• Create join relationships between queries

• Combine data containers based on relationships from different queries

Create a report comparing the percentage of change

Introduction to dimensional reporting concepts

• Examine data sources and model types

• Describe the dimensional approach to queries

Apply report authoring styles

Introduction to dimensional data in reports

• Use members to create reports

• Identify sets and tuples in reports

Use query calculations and set definitions

Dimensional report context

• Examine dimensional report members

• Examine dimensional report measures

Use the default measure to create a summarized column in a report

Focus your dimensional data

• Focus your report by excluding members of a defined set

• Compare the use of the filter() function to a detail filter

Filter dimensional data using slicers

Calculations and dimensional functions

• Examine dimensional functions

• Show totals and exclude members

Create a percent of base calculation

Create advanced dynamic reports

• Use query macros

• Control report output using a query macro

• Create a dynamic growth report

Create a report that displays summary data before detailed data and uses singletons to summarize information

Design effective prompts

• Create a prompt that allows users to select conditional formatting values

• Create a prompt that provides users a choice between different filters

• Create a prompt to let users choose a column sort order

Create a prompt to let users select a display type

Examine the report specification

• Examine report specification flow

• Identify considerations when modifying report specifications

Customize reporting objects

Distribute reports

• Burst a report to email recipients by using a data item

• Burst a list report to the IBM Cognos Analytics portal by using a burst table

Burst a crosstab report to the IBM Cognos Analytics portal by using a burst table and a master detail relationship

Enhance user interaction with HTML

• Create interactive reports using HTML

• Include additional information with tooltips

Send emails using links in a report

Introduction to IBM Cognos Active Reports

• Examine Active Report controls and variables

• Create a simple Active Report using Static and Data-driven controls

• Change filtering and selection behavior in a report

Create interaction between multiple controls and variables

Active Report charts and decks

• Create an Active Report with a Data deck

• Optimize Active Reports

Create an Active Report with new visualizations