IBM Cognos Analytics Author Reports Advance (V11.1.x)

Duration

2 days

Audience

Report Authors and Business Analysts

Prerequisites:

You should have:

• Prior experience using IBM Cognos Analytics
• Knowledge of your business requirements
• Experience using the Windows operating system
• Experience using a Web browser

Objectives

• How to create query models and reports based on query relationships
• Dimensional reporting concepts
• Dimensional data in reports and report context
• How to focus your dimensional data
• Calculations and dimensional functions
• Creating advanced dynamic reports
• Designing effective prompts
• Examining the report specification
• Distributing reports
• Enhancing user interaction with HTML
• An introduction to IBM Cognos Active Reports
• Active Report charts and decks

Contents

Create query models

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

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

Introduction to dimensional reporting concepts

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

Introduction to dimensional data in reports

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

Dimensional report context

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

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

Calculations and dimensional functions

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

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

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

Examine the report specification

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

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

Enhance user interaction with HTML

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

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

Active Report charts and decks

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

Programme scope, delivery arrangements and suitability are confirmed during enquiry.