Schulung - IBM B6259G - IBM Cognos Analytics: Author Reports Advanced (V11.1.x)

Course Outline

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 Deck
Create an Active Report with 11.0 visualizations

Objective

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

Enhance user interaction with HTML 
Create interactive reports using HTML 
Include additional information with tooltips 
Send emails using links in a report

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

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 Deck 
Create an Active Report with 11.0 visualizations