IBM Cognos Analytics Author Reports Fundamentals V11.1.x B6258G

Duration: 
3 days
Codes: 
B6258G
Versions: 
V11.1.X

Overview

This course provides authors with an introduction to build reports using Cognos Analytics. Techniques to enhance, customize, and manage reports will be explored. Activities will illustrate and reinforce key concepts during this learning opportunity.

Skills Gained

  • What is IBM Cognos Analytics - Reporting?
  • Dimensionally modeled relational data
  • Use personal data sources and data modules
  • Examine list reports
  • Aggregate fact data
  • Multiple facts and repeated information
  • Add repeated information to reports
  • Create crosstab reports
  • Create complex crosstab reports
  • Work with crosstab data
  • Create discontinuous crosstab reports
  • Create visualization reports
  • Focus reports using filters
  • Focus reports using prompts
  • Use calculations
  • Customize reports with conditional formatting
  • Drill-through definitions
  • Enhance report layout
  • Use additional report-building techniques

Prerequisites

  • Knowledge of your business requirements
  • Experience using IBM Cognos Analytics as a consumer

Course Outline

What is IBM Cognos Analytics - Reporting?

  • The Welcome page
  • Consume report content
  • Interactive filtering

Working with reports

Dimensionally modeled relational data

Use personal data sources and data modules

  • Upload personal data
  • Upload custom images

Using navigation paths in a data module

Examine list reports

  • Group data
  • Format columns

Include headers and footers

Aggregate fact data

Identify differences in aggregation

Multiple facts and repeated information

  • Use shared dimensions to create multi-fact queries

Present repeated information

Add repeated information to reports

Create a mailing list report

Create crosstab reports

  • Add measures to a crosstab

Data sources for a crosstab

Customize reports with conditional formatting

  • Three steps for conditional formatting
  • Create a variable
  • Assign the variable to a report object
  • Format based on the conditional value

Conditionally render report objects

Drill-through definitions

Navigate to related data

  • Add items as peers

Create crosstab nodes and crosstab members

Work with crosstab data

Format, sort, and aggregate a crosstab

Create discontinuous crosstab reports

Create visualization reports

  • Visualization categories
  • Customize visualizations
  • Client side visualizations

Enhanced map visualizations

Focus reports using filters

  • Create filters to narrow the focus
  • Use advanced detail filters
  • Apply a filter with aggregation

Use summary filters

Focus reports using prompts

  • Examine parameters and prompts
  • Create a parameter for a report item
  • Add a prompt page
  • Add a prompt item to a report
  • Identify a prompt type

Create a cascading prompt

Use calculations

  • What are calculations?
  • Add Date and Time functions
  • Add string functions

Display prompt selections in report titles

Enhance report layout

  • View the structure of a report
  • Use Guided report layout
  • Force page breaks
  • Create horizontal pagination
  • Modify the report structure

Format objects across reports

Use additional report-building techniques

  • Enhance a report design
  • Add objects to reports
  • Convert a list to a crosstab

Explore reuse

Related Courses

 

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

ITILv3, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O, MoP, MoV courses on this page are offered by QA Affiliate of AXELOS Limited. ITIL, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O,MoP, MoV are registered trademarks of AXELOS Limited. All rights reserved.