IBM Cognos Integration Server Extract Data from Oracle HFM (V10.2)

  • Tuition USD $99
  • Reviews star_rate star_rate star_rate star_rate star_half 1063 Ratings
  • Course Code P8219G-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 HFM teaches consumers how to extract data and metadata from Hyperion Financial Management (HFM) 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 (ICIS). 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 needing immediate access to, and interaction with, HFM data in a timely, personalized and secure manner
  • Administrator who need to understand the basic features of ICIS

Prerequisites

You should have:

  • Basic knowledge of Oracle HFM©
  • 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-
  • 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 Hierarchies
  • Overview of steps required to use Cognos Integration Server

The Connection Manager

  • Create a connection
  • Test a connection
  • Clone a connection
  • Delete a connection
  • Determine where a connection is used
  • Edit a connection
  • Export a connection
  • Import a connection
  • Sort the connection list
  • Demo
    • Create and test a source connection for HFM
    • Create and test a target connection for SQL Server

The Selection Manager

  • Choose a source and a target connection
  • Fill in column selection Information
  • Examine the outline construct
  • Create a Point of View
  • Star Schema options
  • Star Schema Dimension Table layout
  • Metadata extraction options
  • Data extraction options
  • Saving and running a selection
  • Other toolbar options
  • Search for outline members
  • Demo: Create a Saved Selection for HFM by
    • Choosing source and target connections
    • Selecting the dimensions to export
    • Creating a  Point of View
    • Run the selection and observe the output in SQL Server
    • Change the Fact Table and Dimension Table layouts
    • Run the selection again and observe the changes in the SQL Server output

The Log Viewer

  • The display
  • The control bar
  • Filtering
  • Sample run detail

The Command Line Interface

  • List connections
  • List all Member of a Selection ID
  • Run a Selection by name
  • Run specific Selection IDs
  • Update Selection from previously-exported selection file

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.

The course is perfectly designed with material and labs to get hands on experience on AWS, nicely done!

Had a good time taking course with ExitCertified. The Data Science course with Python was really laid out well and it was very easy to understand and navigate. The setup using Anaconda was really good and it was easy to follow along and do the practise exercises.

The entire AWS Essentials Course was great! ExitCertified supplied everything we need ahead of time and all went smoothly.

Interesting real world examples and scenarios covered in the training, brought some new perspectives to light.

Class material was clear and well communicated. Virtual setup was easy. Plenty of material was provided ahead of time. Sean was a fantastic instructor.

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