Integration Services is becoming a more integral part of solutions in companies where data staging areas have been setup. In System 9, Integration Services is offered as part of the base Analytic Services product so all new customers of Essbase will have this automatically. This two-day course is designed to help developers push metadata and data from relational databases to Essbase using EIS. We walk through the basics of the EIS software building a model and two metaoutlines during the first day. The second day covers more advanced concepts of the EIS such as handling transformations, adding calculations, creating Drill-through Reports, and more.

Here is the course description for this 2 day class in detail:

EIS Basics

• The Metadata Catalogue
• What is Metadata?
• What does the Metadata Catalogue do?
• The Metadata Catalogue’s job
• Transferring Models and Metaoutlines to Different Catalogues
• EIS and Essbase
• EIS vs Essbase – Data Source Requirements
• EIS Data Staging Area

Getting Started – The Two Sides of EIS

• The Two Sides of EIS
• The Model (work flow steps)
• Creating the Model
• Working with the Model Panel and Toolbar
• The Fact Table
• Adding Additional Dimensions
• Edit/Transform Columns
• Join Dimension Tables
• Create Hierarchies

Getting Started – The Second Side

• Working with the Metaoutline Panel and Toolbar
• Adding Hierarchies
• Adding Members
• Adding Formulas
• Assigning Aliases
• Defining Attribute Dimensions
• Steps to Create the Attribute Dimension in the Metaoutline
• The Metaoutline – Setting up to Run the Process
• Defining Hybrid Analysis
• Running a Member Load Process
• Running a Data Load Process

EIS Advanced

• Steps to Create a New Column
• Transformation Rules
• Working with Date Type Transformations
• Pass-Through
• Adding Calculations
• Recursive Tables and Self-Join
• Handling Table Changes
• Creating Drill-through Reports
• Filters
• Using SQL Override
• Working with Your Own Locks
• Working with Other User Locks