Introduction:

IBM  Cognos Integration Server Training curriculum makes learner familiar with extracting the data from sales, operational and financial applications of varied sources. The learning module of the course is so designed that it helps users drive growth and manage risks with Cognos Integration Server

Course Content:

1.Introduction

• Course overview
• Intended audience
• Course objectives
• Prerequisites

2.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

3.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

4.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

5.Demo

• Create and test a source connection for HFM
• Create and test a target connection for SQL Server

6.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

7.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

8.The Log Viewer

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

9.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