COGNOS BI & TM1

INTRODUCTION TO QUERY STUDIO

List the packages available for reporting

Understand report types

Add and save data to ad hoc reports

View data by using charts

CREATE REPORTS IN QUERY STUDIO

Create list, grouped list, and crosstab reports

List the charts available and their appropriate use

Calculate and sort report data

Define a custom group to create your own report

Use shared dimensions to create multi-fact queries

ENHANCE REPORTS IN QUERY STUDIO

Highlight report items using conditional styles

Focus the scope of a report using filters

Format report objects

Apply a report template

INTRODUCTION TO THE REPORTING APPLICATION

discuss different modes of reporting

examine Report Studio and its interface

explore different report types

create a simple, sorted, and formatted report

explore how data items are added to queries

CREATE LIST REPORTS

group, format, and sort list reports

describe options for aggregating data

create a multi-fact query

create a report with repeated data

CREATE REPORTS BASED ON QUERY RELATIONSHIPS

create reports by merging query results

create reports by joining queries

combine data containers based on relationships from different queries

DISTRIBUTE REPORTS THROUGH BURSTING

distribute reports using bursting

create burst keys

identify report recipients and data items using burst tables

distribute reports using email and IBM Cognos Connection

CREATE ADVANCED DYNAMIC REPORTS

filter reports on session parameter values

navigate a briefing book using a table of contents

create dynamic headers and title that reflect report data

let users navigate to specific locations in reports

create a customer invoice report

DESIGN EFFECTIVE PROMPTS

control report displays using prompts

specify conditional formatting values using prompts

create a report that formats based on prompts selection

create a sorted and filtered report based on prompt selection

CREATE ADDITIONAL ADVANCED REPORTS

create a report that displays summarized data before detailed data

highlight alternate rows in a list report

FOCUS REPORTS USING FILTERS

create filters to narrow the focus of reports

examine detail and summary filters

determine when to apply filters on aggregate data

CREATE CROSSTAB REPORTS

format and sort crosstab reports

create complex crosstabs using drag and drop functionality

create crosstabs using unrelated data items

create charts containing peer and nested columns

present data using new chart type options

add context to charts

present key data in a single dashboard report

FOCUS REPORTS USING PROMPTS

identify various prompt types

use parameters and prompts to focus data

search for prompt types

navigate between pages

EXTEND REPORTS USING CALCULATIONS

create calculations based on data in the data source

add run-time information to the reports

create expressions using functions

DESIGN EFFECTIVE REPORTS

enhance report design with report objects

reuse objects within the same report

share layout components among separate reports

CUSTOMIZE REPORTS WITH CONDITIONAL FORMATTING

create multi-lingual reports

highlight exceptional data

show and hide data

conditionally render objects in reports

conditionally format one crosstab measure based on another

DRILL-THROUGH FROM ONE REPORT TO ANOTHER

let users navigate from a specific report to a target report

pass parameter values to filter the data in drill-through targets

navigate through multiple reports

DRILL-THROUGH DEFINITIONS

discuss parameter-driven drill through

discuss dynamic drill through

set up package-based drill-through definitions

set scope

use the Drill Through Assistant

MANAGE CONTENT IN IBM COGNOS CONNECTION

schedule and manage reports

view lineage information

organize content

examine IBM Cognos Connection personal preferences

set alerts and watch rules

design a portal page and dashboard

set permissions using IBM Cognos 10 BI groups and roles

EXAMINE THE REPORT SPECIFICATION

examine the report specification structure

save and edit reports locally

discuss considerations for modifying a report specification

CREATE QUERY MODELS

build query models and then connect them to the report layout

add filters and prompts to a report using the query model

edit an SQL statement to author custom queries

ANALYSIS STUDIO FUNDAMENTALS

Define the fundamental terms of Analysis Studio

Explain how to insert objects

Define and create sets

Identify the work area, overview area, and properties pane

TOOLS FOR INVESTIGATION IN ANALYSIS STUDIO

Employ drilling down and up to different levels of detail

Apply changes to rows, columns, and measures in the analysis

Explain how to change the display of data

Use charts to display data graphically

NEST DATA IN CROSSTABS IN ANALYSIS STUDIO

Apply depth to rows and columns by nesting data

Recognize drill behavior in nested rows and columns

Demonstrate how to swap nested levels

BUILD ADVANCED CROSSTABS IN ANALYSIS STUDIO

Demonstrate how to view a complete level of data

Design a crosstab without retrieving data

Compare multiple measures

Apply stacked sets to the crosstab

Construct an asymmetrical crosstab

Compose a custom sort

APPLY FILTERS USING EXPRESSIONS

Apply filters using the Context area

Create top and bottom lists

Use several techniques to remove rows and columns

FRAMEWORK MANAGE (METADATA MODELING)

Introduction to Framework Manager

Framework Manager Basics

User Interface, Navigation, Objects

Designing Project

Create project

Importing Metadata

Exporting Metadata

Create Model Documentation

Data Sources

Working with Data Source Connections

Create and Modify Data Sources

Improve Performance by setting Query Processing Type

Preparing Relational Metadata for use in Reports

Verifying Relationships

Working with Dimensions

Working with Query Subjects

Working with Query Items

Supporting Multilingual Metadata

Adding Business Rules

Organizing the Model

Making Metadata Available to Report Authors

Verify Model

Set Governors

Improving Performance

Create or Modify Package

Controlling access to Metadata

Explore Package

Publish Package

Guideline for Modeling Metadata

Scenarios

New Objects - Regular Dimensions, Measure Dimension

BUSINESS INSIGHT

Business Insight Advanced

Active Reports

Manage External Data

List Enhancements

Custom Properties for Prompts

Enhancements to the User Interface