Uddannelsestilbud

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

Information

Pris kr 2.000  Ekskl. moms
Varighed: 1 Dag
Courseware : Included
Ref: P8219G
Delivery Type Web based training

Sessionsdatoer

På anmodning. Kontakt os venligst

Purchase

    BUY Now
    kr 2.000  Ekskl. moms

    Ekskl. moms

Disse oplysninger findes også beregnet for intra-virksomhedsuddannelsen. Tøv ikke med at kontakte os for at få flere oplysninger

Beskrivelse

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.



http://www.ibm.com/training/terms

Formål

Please refer to Course Overview for description information.

Målgruppe

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

Forudsætninger

You should have:




  • Basic knowledge of Oracle HFM©

  • Basic knowledge of Microsoft SQL Server©

  • Experience using basic Windows functionality

Program

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

© 2018 VALit Aps - Arrow ECS. All rights reserved.