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
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.

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 [email protected]

Privacy Notice