> > > J1173G

IBM Cognos Express: Essentials for Reporter (V10.1) SPVC

 

Who should attend

This intermediate course is for Advanced Users and Administrators.

Prerequisites

You should have:

  • Knowledge of your business requirements
  • Experience using the Windows operating system and a Web browser
  • Completion of IBM Cognos Express (V10.1) Overview

Product Description

IBM Cognos Express: Essentials for Reporter (V10.1) is a five-day Self Paced Virtual Classroom (SPVC) course that provides you with knowledge on how to get started building self-service and professional reports using IBM Cognos Express Reporter. Fundamental topics on report authoring, multi-dimensional authoring, and metadata modeling are covered.

If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.

http://www.ibm.com/training/terms

Outline

Overview of IBM Cognos BI  

  • Describe IBM Cognos BI components

Identify Common Data Structures

  • Identify different data traps
  • Examine OLAP data sources

Create a Baseline Project

  • Define a project and its structure

Prepare Reusable Metadata

  • Verify relationships and query item properties

Model for Predictable Results: Identify Reporting Issues

  • Use tools to analyze the model

Model for Predictable Results: Virtual Star Schemas

  • Identify the advantages of modeling metadata as a star schema
  • Model in layers

Create Calculations and Filters

  • Use calculations to create commonly-needed query items for authors
  • Use macros and parameters in calculations and filters to dynamically control the data returned

Implement a Time Dimension

  • Make time-based queries simple to author by implementing a time dimension

Specify Determinants

  • Use determinants to specify multiple levels of granularity and prevent double-counting

Create Analysis Objects

  • Apply dimensional information to relational metadata to enable OLAP-style queries

Set Security in Framework Manager

  • Restrict access to objects in the model

Introduction to Reporting Application

  • Create a simple, sorted, and formatted report

Create List Reports

  • Group, format, and sort list reports
  • Create a multi-fact query

Focus Reports Using Filters

  • Create filters to narrow the focus of reports
  • Examine detail and summary filters

Create Crosstab Reports

  • Format and sort crosstab reports

Present Data Graphically

  • Create charts containing peer and nested items

Focus Reports Using Prompts

  • Identify various prompt types
  • Use parameters and prompts to focus data

Extend Reports Using Calculations

  • Add run-time information to the reports
  • Create expressions using functions

Customize Reports with Conditional Formatting

  • Create multi-lingual reports
  • Highlight exceptional data

Drill-Through From One Report to Another

  • Pass parameter values to filter the data in drill-through targets

Introduction to IBM Cognos Active Report

  • Examine an active report and its controls
  • Convert an existing report to an active report

Filter and Select in Active Reports

  • Distinguish between filter and select

Active Reports with Support for Mobile for iPad

  • Identify how to use controls to capitalize on the functionality of mobile devices

Introduction to Dimensional Data in Reports

  • Define and use members in reports
  • Define and use sets in reports

Dimensional Report Context

  • Understand current members, root members and default members
  • Understand current measures and default measures

Focus Your Dimensional Data

  • Compare relational and dimensional queries
  • Identify dimensional style filtering techniques

Calculations and Dimensional Functions

  • Create totals and aggregates
  • Combine functions for complex calculations
E-Learning IBM Self-Paced Virtual Class (SPVC)

Price on request

BUY NOW
 

Accessing our website tells us you are happy to receive all our cookies. However you can change your cookie settings at any time. Find out more.   Got it!