Verhoef Training USA

Training Courses and On-Line Classes Preferred By IT Pros

Visit us at:   http://www.verhoef-training.com

103 Hillside Ave., PO Box 1515
West Caldwell, NJ 07006
Main Office:  800.631.0410
Sales Office:  800.533.3893

IBM Cognos Framework Manager

Course:   COGNOSFM
Duration:   2 Days
Level:   I
On our website at:   http://www.verhoef-training.com/courses/COGNOSFM.html
 
Course Summary

This 2 day course is designed to provide an introduction to the key concepts required to build models and use Framework Manager for Cognos 10. It provides participants with knowledge on how to model metadata with Framework Manager and publish packages for report users. Throughout the course, participants will model both operational and star schema metadata for predictable results, as well as create a dimensional model to be used for OLAP style querying.

Topics Covered In This Course

MODULE 1

Cognos Architecture

  • Cognos Connection
  • Data Sources
  • Reporting Packages
  • Project Lifecycle

MODULE 2

Framework Manager Introduction

  • The Project Interface
  • Naming Conventions
  • Project Workflow
  • Creating data sources
  • Prepare Metadata

MODULE 3

Prepare Metadata

  • Query and Measure Items
  • Creating Relationships
  • Creating Calculations
  • Parameters and Macros

MODULE 4

Model for predictable results

  • Modelling Star Schemas
  • Identify Reporting traps
  • Facts and Dimensions
  • Implementing a Time dimension

MODULE 5

Creating Business Views

  • Create a Business View
  • Populating the business view
  • Conformed Dimensions
  • Dimensionally modelled relational data
  • Determinants and Regular Dimensions

MODULE 6

Setting Security

  • Cognos Security Model
  • Authentication Providers
  • Setting Security in the Cognos Namespace
  • Package and Data Security

MODULE 7

Manage OLAP sources

  • Differences between relational and OLAP Modelling
  • OLAP data source types
  • Connect to an OLAP data source
  • Publish an OLAP source
What You Can Expect

Provides participants with knowledge on how to model metadata with Framework Manager and publish packages for report users.

Training Style

Throughout the course, participants will model both operational and star schema metadata for predictable results, as well as create a dimensional model to be used for OLAP style querying.

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.