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

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?
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 aPoint 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

Aim

Please refer to Course Overview for description information.

Participant requirements

You should have:

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

Participant

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