Course outline

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

Categories: Guaranteed To Run™, IBM

GK IBM LS Partner

Duration: 0.2 Day

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.

http://www.ibm.com/training/terms

Please refer to Course Overview for description information.

You should have:

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

This intermediate course is for:

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

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
This course is delivered by an authorized IBM Global Training Provider.

Feel free to contact us, if you want to know the price and location of this course. A Digital Revolver representative will contact you shortly to help you with your inquiry.
Please fill out the form below

  • Guaranteed to Run™. This ensures you will attend the instructor led class or live online class you want as scheduled without any disruptive cancellations*. You book the training you need, get back to focusing on your job and are sure your training requirements will be met saving time, money and ensuring peace of mind.
  • This schedule icon the schedule indicates that this date/time will be conducted as Instructor Led Training (ILT) or a Virtual Instructor Led Training (VILT) depending on the indicated class availablity.
Privacy and Cookies

This website stores cookies on your computer which help us make the website work better for you.

Learn moreAccept and Close
Social media & sharing icons powered by UltimatelySocial