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

  • Tuition USD $99
  • Reviews star_rate star_rate star_rate star_rate star_half 1172 Ratings
  • Course Code P8218G-WBT
  • Duration 1 hour
  • Available Formats Self Paced

This IBM Web-Based Training (WBT) is Self-Paced and includes:
- Instructional content available online for duration of course
- Visuals without hands-on lab exercises

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.

Skills Gained

Please refer to Course Overview for description information.

Who Can Benefit

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

Course Details

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

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

TX3181/3191 Courses. Really good course, highly recommended for TWS/D users.

It's a good platform overall, quality is all dependent on instructor and course content

Very well organized. All the course documents, presentations, meetings worked well.

Great training platform, signing up for courses is made easy and a great customer support team is there to answer any question and provide assistance during application. The course was great overall, instructor explained everything throughly and quickly answer any incoming questions.

The course provided the essentials in preparing for AWS certification. Material was well organized and utilized during topic discussions.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward