Tag Archives: IBM Cognos Integration Server Interview Questions And Answers

IBM Cognos Integration Server Training

Enroll for expert level Online IBM Cognos Integration Server Training by Spiritsofts, Learn IBM Cognos Integration Server Certification Training with Course Material, Tutorial Videos, Attend Demo for free & you will find Spiritsofts is the best Online Training Institute within reasonable fee.

Spiritsofts is the best Training Institutes to expand your skills and knowledge. We Provides the best learning Environment. Obtain all the training by our expert professionals which is having working experience from Top IT companies.

The Training in is every thing we explained based on real time scenarios, it works which we do in companies.

IBM Cognos Integration Server Course Content

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

 

  • 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

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 connections
  • List all Member of a Selection ID
  • Run a Selection by name
  • Run specific Selection IDs
  • Update Selection from previously-exported selection file
Top ↑