Objectives

  • What is IBM Cognos Analytics Reporting
  • Examine dimensionally modelled and dimensional data sources
  • Examine personal data sources and data modules
  • Examine List reports
  • Aggregate measure/fact data
  • Use shared dimensions to create multi-fact queries
  • Add repeated information to reports
  • Create crosstab reports
  • Create complex crosstab reports
  • Format, sort, and aggregate data in a crosstab report
  • Create discontinuous crosstab reports
  • Create Visualization reports
  • Add business logic to reports using IBM Cognos Analytics Reporting
  • Focus reports using filters
  • Focus reports using prompts
  • Augment reports using calculations
  • Extend report functionality in IBM Cognos Analytics Reporting
  • Customize reports with conditional formatting
  • Conditionally format one crosstab measure based on another
  • Drill-through definitions
  • Enhance the report layout
  • Use additional report building techniques

Audience

Report Authors

Prerequisites

  • Knowledge of your business requirements
  • IBM Cognos Analytics for Consumers (v11.0) WBT or equivalent knowledge

Duration

Three days

Outline for IBM COGNOS ANALYTICS: AUTHOR REPORTS FUNDAMENTALS (V11.0.X) Training

Chapter 1. What is IBM Cognos Analytics Reporting-

  • Create a simple list report
  • Create a report from a dimensionally modeled relational data source

Chapter 2. Examine personal data sources and data modules

  • Upload personal data
  • Upload custom images
  • Use navigation paths
  • Create a report from a personal data source

Chapter 3. Examine list reports

  • Group data in a list
  • Format columns in a list
  • Include headers and footers in a list
  • Enhance a list report

Chapter 4. Aggregate measure/fact data

  • Identify differences in aggregation
  • Explore data aggregation

Chapter 5. Use shared dimensions to create multi-fact queries

  • Create a multi-fact query in a list report

Chapter 6. Add repeated information to reports

  • Create a mailing list report

Chapter 7. Create crosstab reports

  • Add measures to a crosstab
  • Data sources for a crosstab
  • Create a simple crosstab report

Chapter 8. Create complex crosstab reports

  • Add items as peers
  • Create crosstab nodes and crosstab members
  • Create a complex crosstab report

Chapter 9. Format, sort, and aggregate data in a crosstab

  • Sort, format, and aggregate a crosstab report

Chapter 10. Create discontinuous crosstab reports

  • Present unrelated items using a discontinuous crosstab

Chapter 11. Create a visualization report

  • Create and format a visualization report
  • Create a report that uses a Map visualization
  • Show the same data graphically and numerically

Chapter 12. Focus reports using filters

  • Apply filters to a report
  • Apply a detail filter on fact data in a report
  • Apply a summary filter to a report

Chapter 13. Focus reports using prompts

  • Create a prompt by adding a parameter
  • Add a value prompt to a report
  • Add a Select & search prompt to a report
  • Create a cascading prompt

Chapter 14. Augment reports using calculations

  • Add calculations to a report
  • Display prompt selections in the report title

Chapter 15. Customize reports with conditional formatting

  • Create a multilingual report
  • Highlight exceptional data and conditionally render a column

Chapter 16. Drill-through definitions

  • Let users navigate to related data in IBM Cognos Analytics

Chapter 17. Enhance report layout

  • Create a report structured on data items
  • Create a condensed list report

Chapter 18. Use additional report building techniques

  • Section a report and reuse objects within the same report
  • Reuse layout components in a different report
  • Explore options for reports that contain no data