IBM Cognos Framework Manager

Course:  COGNOSFM
Duration:  2 Days
Level:  I
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.

« Hide The Details
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.

« Hide The Details

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.

Schedule For This Course
11/13/2017
St. Paul, MN
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com