This course teaches experienced authors advanced report building techniques to enhance, customize, manage, and distribute reports. Additionally, the student will learn how to create highly interactive and engaging reports that can be run offline by creating Active Reports.

starstarstarstarstar_outline

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

Please refer to course overview

1

  • Create query models

  • Build a query and connect it to a report
    Answer a business question by referencing data in a separate query
2

  • 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
3

  • Introduction to dimensional reporting concepts

  • Examine data sources and model types
    Describe the dimensional approach to queries
    Apply report authoring styles
4

  • Introduction to dimensional data in reports

  • Use members to create reports
    Identify sets and tuples in reports
    Use query calculations and set definitions
5

  • Dimensional report context

  • Examine dimensional report members
    Examine dimensional report measures
    Use the default measure to create a summarized column in a report
6

  • 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
7

  • Calculations and dimensional functions

  • Examine dimensional functions
    Show totals and exclude members
    Create a percent of base calculation
8

  • 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
9

  • 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
10

  • Examine the report specification

  • Examine report specification flow
    Identify considerations when modifying report specifications
    Customize reporting objects
11

  • 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
12

  • Enhance user interaction with HTML

  • Create interactive reports using HTML
    Include additional information with tooltips
    Send emails using links in a report
13

  • 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
14

  • Active Report charts and decks

  • Create an Active Report with a Deck
    Create an Active Report with 11.0 visualizations

Audience

Experienced IBM professionals will benefit.

Language

English

Prerequisites

While there are no prerequisites for this course, please ensure you have the right level of experience to be successful in this training.

$1,650

Length: 2.0 days (16 hours)

Level:

Not Your Location? Change

Course Schedule:

Schedule select
19
Oct
Thursday
9:30 AM ET -
5:30 PM ET
Filling Fast
Available
Schedule select
16
Nov
Thursday
9:30 AM ET -
5:30 PM ET
Filling Fast
Available
Schedule select
14
Dec
Thursday
9:30 AM ET -
5:30 PM ET
Filling Fast
Available
Schedule select
25
Jan
Thursday
9:30 AM ET -
5:30 PM ET
Filling Fast
Available
Schedule select
29
Feb
Thursday
9:30 AM ET -
5:30 PM ET
Filling Fast
Available
Loading...