212-824-2900
info@mtgny.com

 

Essbase Integration Services: Create and Manage Data Structures

Introduction

  • Overview of business information analysis, OLAP concepts, and data warehouses
  • Integration process overview
  • Starting and stopping Essbase Integration Services
  • Navigating the Essbase Integration Services console
  • Connecting to relational data sources
  • Essbase Integration Services architecture
  • Installing Essbase Integration Services
  • Configuring Essbase Integration Services

Preparing Relational Data Sources

  • Data normalization and denormalization overview
  • Creating entity-relationship and dimensional database models as sources
  • Consolidating data into a single data source
  • Creating views and tables
  • Preparing an existing star schema

Designing Essbase Analytic Services Outlines

  • Building Essbase Analytic Services outlines
  • Loading Essbase Analytic Services databases
  • Retrieving data with Hyperion Essbase Spreadsheet Add-in
  • Designing Essbase Analytic Services outlines from OLAP models

Creating OLAP Models

  • Defining the OLAP model
  • Opening a new OLAP model
  • Examining source tables and views
  • Selecting a fact table and dimension tables
  • Defining joins
  • Assigning properties to tables and columns
  • Defining hierarchies
  • Validating and saving OLAP models

Creating Metaoutlines

  • Overview of metaoutline features and components
  • Creating a metaoutline
  • Opening a new metaoutline
  • Adding dimensions, member levels, and measures
  • Setting filters
  • Assigning Essbase Analytic Services properties
  • Setting load properties
  • Previewing sample outlines
  • Validating and saving metaoutlines

Creating and Loading Essbase Analytic Services Databases

  • Building Essbase Analytic Services outlines
  • Starting a member load
  • Scheduling a member load
  • Loading Essbase Analytic Services databases
  • Starting a data load
  • Scheduling a data load
  • Saving, viewing, and deleting member and data loads

Creating Drill-Through Reports

  • Overview of drill-through reporting
  • Setting up drill-through reports
  • Specifying spreadsheet user actions
  • Using drill-through reports
  • Updating drill-through information
  • Customizing drill-through report results

Advanced Topics

  • Designing accounts and measures dimensions
  • Using SQL override
  • Defining business calendars
  • Defining alternate and ragged hierarchies
  • Restructuring relational data

Troubleshooting and Administrative Tasks

  • Copying and renaming OLAP models and metaoutlines
  • Using XML import and export
  • Viewing the server log file
  • Automating processes with the Essbase Integration Services shell

Hybrid Analysis

  • Preparing for Hybrid Analysis
  • Hybrid Analysis Results - Using the Hyperion Essbase Spreadsheet Add-in
  • Updating Hybrid Analysis information

Case Study--The Eight Phases of the Essbase Integration Services Integration Process

  • Identifying the business information requirements
  • Examining and preparing the relational data source
  • Designing the Essbase Analytic Services outline
  • Creating the OLAP model
  • Creating the metaoutline
  • Building the Essbase Analytic Services outline
  • Loading the Essbase Analytic Services database
  • Analyzing information by using Hyperion analysis tools

For general training questions or to schedule classroom training, please contact Hyperion Education Support at 203-703-3535 or via education@hyperion.com.

MTG's Training Center is based in the New York Information Technology Center in the heart of New York's Financial District.  For information about convenient local transportation, lodging, and business services, please contact us at 212-824-2900 or info@mtgny.com.