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

Course Code: P8218G
Duration: 1.6 Hours
Price: Contact For Pricing

e-Learning

Close

Learn at your own pace with anytime, anywhere training.

Contact For Pricing

Classroom Schedule

Close

There are no classes currently scheduled

* Prices Inclusive of taxes

View All Our Training Schedule

Virtual Schedule

Close
Location Delivered By Language Date Price Action
No schedule date's available now.

* Prices Inclusive of taxes

View All Our Training Schedule

Private / Corporate Training

Close

Tell us a little about yourself:

Course Description

  • IBM Cognos Integration Server: Extract Data From Oracle Essbase teaches consumers how to extract data, metadata and security profiles from Oracle Essbase, and make it available for use in standard relational and text format targets, including IBM Cognos TM1. The course is not intended to describe the detailed architecture, configuration, or administration of IBM Cognos Integration Server. The vignette is taught in a web-based, eLearning format.

    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.

Objectives

  • Please refer to Course Overview for description information.

Audience

  • This intermediate course is for:

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

Prerequisites

  • You should have:

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

Content

  • 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

  • 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
  •  
  • Common Hyperion Cube terminology
  • Parent/Child vs. Balanced Hierarchy layouts
  • Oracle Essbase terminology
  • Overview of steps required to use Cognos Integration Server