A03 Reporting (IBM Cognos Analytics)

Name: A03 Reporting (IBM Cognos Analytics)
Rating: 4.2 (27 reviews)

Report creation with IBM Cognos 11 Analytics

Created byNick Netzig

Last updated 5/2020

English

What you'll learn

During the introduction to Cognos Reporting , the most important components of complex report generation are trained. Focus is on objects for report design.
Lists, Crosstabs, Charts
Page Preview, Page Design
Cognos Reporting Tipps and Tricks

Course content

12 sections • 39 lectures • 3h 45m total length

A3-01 Introduction to Cognos Reporting5:08
Topics in this lesson:
Overview of the interface for creating reports
goal of this lesson:
You will learn how to create reports in Cognos Analytics and create a simple list report.

A03-02-1 List Reports - Sorting and Grouping5:01
Topics in this lesson:
Insert, move and rename columns
Group
Sort
Automatic Aggregation
headers and footers of the list
goal of this lesson:
You will create a grouped and sorted list report with key figures and add footers for subtotals and totals.
A03-02-2 Add Groupings4:32
Topics in this lesson:
Insert, move and rename columns
Group
Sort
Automatic Aggregation
headers and footers of the list
goal of this lesson:
You will create a grouped and sorted list report with key figures and add footers for subtotals and totals.
A03-02-3 Advanced sorting options5:28
Topics in this lesson:
Insert, move and rename columns
Group
Sort
Automatic Aggregation
headers and footers of the list
goal of this lesson:
You will create a grouped and sorted list report with key figures and add footers for subtotals and totals.
A03-02-4 Summaries and custom aggregation3:05
Topics in this lesson:
Insert, move and rename columns
Group
Sort
Automatic Aggregation
headers and footers of the list
goal of this lesson:
You will create a grouped and sorted list report with key figures and add footers for subtotals and totals.

A03-03-1 Create cross tables3:42
Topics in this lesson:
Inserting and nesting of columns and rows
Create totals columns and rows
Cross-table design of spaces, text objects and insertion of column headings
goal of this lesson:
You will create an asymmetrically nested cross table with several key figures.
A03-03-2 Working with different measures3:18
Topics in this lesson:
Inserting and nesting of columns and rows
Create totals columns and rows
Cross-table design of spaces, text objects and insertion of column headings
goal of this lesson:
You will create an asymmetrically nested cross table with several key figures.
A3-03 Create cross tables - Part 36:28
Topics in this lesson:
Inserting and nesting of columns and rows
Create totals columns and rows
Cross-table design of spaces, text objects and insertion of column headings
goal of this lesson:
You will create an asymmetrically nested cross table with several key figures.

A03-04-1 Diagrams and visualizations3:14
Topics in this lesson:
Working with visualizations
Working with diagrams
goal of this lesson:
You will create a report with two graphical representations. You will get to know the diagram objects and the visualizations.
A03-04-2 Working with chart objects5:08
Topics in this lesson:
Working with visualizations
Working with diagrams
goal of this lesson:
You will create a report with two graphical representations. You will get to know the diagram objects and the visualizations.

A03-05-1 Filtering data3:08
Topics in this lesson:
Detail filter at data level
Preliminary and post-automatic aggregation
Summary filter
goal of this lesson:
You will define filters in a grouped filter in different ways and learn about the special features of key figure filtering.
A03-05-2 Advanced Filters using the expression editor6:31
Topics in this lesson:
Detail filter at data level
Preliminary and post-automatic aggregation
Summary filter
goal of this lesson:
You will define filters in a grouped filter in different ways and learn about the special features of key figure filtering.
A03-05-3 Measure based filters4:29
Topics in this lesson:
Detail filter at data level
Preliminary and post-automatic aggregation
Summary filter
goal of this lesson:
You will define filters in a grouped filter in different ways and learn about the special features of key figure filtering.
A03-05-4 Working with summary filters2:29
Topics in this lesson:
Detail filter at data level
Preliminary and post-automatic aggregation
Summary filter
goal of this lesson:
You will define filters in a grouped filter in different ways and learn about the special features of key figure filtering.

A03-06-1 Prompts and Prompt Pages6:01
Topics in this lesson:
Working with prompt parameters
Create prompt pages
manual creation and design of user friendly prompts
Cascading Prompts
goal of this lesson:
You will create a prompt page where you can select regions and their countries.
A03-06-2 Using prompts on report pages7:07
Topics in this lesson:
Working with prompt parameters
Create prompt pages
manual creation and design of user friendly prompts
Cascading Prompts
goal of this lesson:
You will create a prompt page where you can select regions and their countries.
A03-06-3 Manual creation of a page5:07
Topics in this lesson:
Working with prompt parameters
Create prompt pages
manual creation and design of user friendly prompts
Cascading Prompts
goal of this lesson:
You will create a prompt page where you can select regions and their countries.
A03-06-4 cascading prompts6:52
Topics in this lesson:
Working with prompt parameters
Create prompt pages
manual creation and design of user friendly prompts
Cascading Prompts
goal of this lesson:
You will create a prompt page where you can select regions and their countries.

A03-07-1 Simple Calculations3:22
Topics in this lesson:
Calculations
Functions
goal of this lesson:
You will create different calculations.
A03-07-2 Advanced Calculations6:04
Topics in this lesson:
Calculations
Functions
goal of this lesson:
You will create different calculations.
A03-07-3 String Calculations4:40
A03-07-4 Summarie Calculations4:21
Topics in this lesson:
Calculations
Functions
goal of this lesson:
You will create different calculations.
A03-07-5 Layout Calculations3:29
Topics in this lesson:
Calculations
Functions
goal of this lesson:
You will create different calculations.

A03-08-1 Formatting Basics5:21
Topics in this lesson:
Formatting data such as texts, dates, numbers and currencies
Transferring formatting to other objects
Using tables and blocks as structure objects
Arranging and aligning objects
Delete and swap format classes
Working with layout components
goal of this lesson:
You will learn the basics of formatting and how to create a uniform layout for many reports.
A03-08-2 Formatting Crosstabs4:30
Topics in this lesson:
Formatting data such as texts, dates, numbers and currencies
Transferring formatting to other objects
Using tables and blocks as structure objects
Arranging and aligning objects
Delete and swap format classes
Working with layout components
goal of this lesson:
You will learn the basics of formatting and how to create a uniform layout for many reports.
A03-08-3 Custom Formats3:29
Topics in this lesson:
Formatting data such as texts, dates, numbers and currencies
Transferring formatting to other objects
Using tables and blocks as structure objects
Arranging and aligning objects
Delete and swap format classes
Working with layout components
goal of this lesson:
You will learn the basics of formatting and how to create a uniform layout for many reports.
A03-08-4 Layout Components4:30
Topics in this lesson:
Formatting data such as texts, dates, numbers and currencies
Transferring formatting to other objects
Using tables and blocks as structure objects
Arranging and aligning objects
Delete and swap format classes
Working with layout components
goal of this lesson:
You will learn the basics of formatting and how to create a uniform layout for many reports.

A03-10-1 Working with queries13:17
Topics of this lesson:
Use queries in multiple data containers
Linking queries with JOIN connections
Merge queries using the UNION function
goal of this lesson:
You will learn how to work with queries.
A03-10-2 Copy and manage queries7:10
Topics of this lesson:
Use queries in multiple data containers
Linking queries with JOIN connections
Merge queries using the UNION function
goal of this lesson:
You will learn how to work with queries.

Requirements

You can participate in this course if you already have access to a Cognos system or have attended our basic courses.

Description

During the introduction to Cognos Reporting , the most important components of professional report generation are trained. The focus is on the different objects for report design. This includes, among other things: list objects, cross-tables, tables, layout components, prompt pages.

Participants will learn how to create pixel-accurate and attractively designed reports on several pages, including cover page and table of contents.

Tips for learning with the webinar videos

The best way to learn is to work through the lessons in the given order
The lessons are self-contained. If you only want to learn or repeat a particular topic, you can also start directly with the lesson.
Practice simultaneously on your own Cognos system
Start a video and press Pause if you want to follow the steps in your own system.
View complicated operations multiple times
After each lesson, you should test and deepen your knowledge with your own data on your system.

Who this course is for:

IBM Cognos 11 users and report creators

A03 Reporting (IBM Cognos Analytics)

What you'll learn

Explore related topics

Course content