1

What is IBM Cognos Analytics - Reporting?

• Home page.
• Use report content.
• Interactive filtering.
• Working with reports.

2

Relational data modeled by different dimensions

3

Use personal data sources and data modules

• Download personal data.
• Download custom images.
• Use of navigation paths in a data module.

4

Review list reports

• Group data.
• Format columns.
• Include headers and footers.

5

Aggregate factual data

• Identify aggregation differences.

6

Multiple facts and repeated information

• Use shared dimensions to create multiple-fact queries.
• Present repeated information.

7

Adding repeated information to reports

• Create a mailing list report.

8

Creating pivot table reports

• Add measures to a pivot table.
• Data sources for a pivot table.

9

Create complex pivot table reports

• Add articles as peers.
• Create pivot table nodes and members.

10

Working with cross-analysis data

• Format, sort and aggregate a pivot table.

11

Create discontinuous pivot table reports

12

Create visualization reports

• Visualization categories.
• Customize visualizations.
• Client-side visualizations.
• Enhanced map visualizations.

13

Detailed reports using filters

• Create filters to sharpen focus.
• Use advanced detail filters.
• Apply a filter with aggregation.
• Use summary filters.

14

Detailed reports using prompts

• Review parameters and prompts.
• Create a parameter for a report element.
• Add a prompt page.
• Add a prompt element to a report.
• Identify a type of prompt.
• Create a cascade prompt.

15

Using calculations

• What are calculations?
• Add date and time functions.
• Add string functions.
• Display prompt selections in report titles.

16

Customize reports with conditional formatting

• Three steps to conditional formatting.
• Create a variable.
• Assign the variable to a report object.
• Format based on conditional value.
• Conditional rendering of report objects.

17

Retail access definitions

• Access related data

18

Improve report layout

• See report structure.
• Use guided reporting.
• Force page breaks.
• Create horizontal pagination.
• Modify report structure.
• Object formatting in reports.

19

Use additional reporting techniques

• Improve report design.
• Add objects to reports.
• Convert a list into a pivot table.
• Explore reuse.