IBM Cognos Integration Server Extract Data From Oracle Essbase (V10.2) - P8218G

Description

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

Introduction

Course overview
Intended audience
Course objectives
Prerequisites

What is Cognos Integration Server?

Key features
Key benefits
How does Integration Server work?
Cognos Integration Server provides a single window into:

Financial data
Metadata
User information
Supporting information



Basic Topics

What Is a Star Schema?
Creating Star Schema tables from a Cube
Common Hyperion Cube terminology
Parent/Child vs. Balanced Hierarchy layouts
Oracle Essbase terminology
Overview of steps required to use Cognos Integration Server

The Connection Manager

Sources and targets
Create a connection
Connection operations
Demo: Create and test source and target connections

The Selection Manager

Selection Information
Star Schema options
Metadata options
Data extraction options
Run a selection
Selection Manager toolbar
Search for Outline Members
Demo: Create and run a Saved Selection

The Log Viewer

Control bar
Filtering
Sample run detail

Integration Server Options

Selection Manager options
Table and column name mapping

Aim

Please refer to Course Overview for description information.

Participant requirements

You should have:

Basic knowledge of Oracle Essbase©
Basic knowledge of Microsoft SQL Server©
Experience using basic Windows functionality

Participant

This intermediate course is for:

Business Intelligence users of Oracle Essbase data
Administrators needing to understand the basic features of IBM Cognos Integration Server