Hyperion Essbase

CloudLabs

Projects

Assignment

24x7 Support

Lifetime Access

.

Course Overview

Oracle Hyperion Essbase is the most advanced financial analytical processing software in the market. Oracle Essbase is a rich environment to develop effective enterprise performance management applications and financial custom analytic reports. Oracle Hyperion Essbase can manipulate data directly in the spreadsheet, via pre-formatted reports, or a powerful ad hoc graphical interface, so that the business users can easily access the data they need to make more profitable decisions.

At the end of the training, participants will be able to:

Pre-requisite

All attendees should have a basic knowledge of OLAP database.

Duarion

5 days

Course Outline

  • Multidimensional View of Information
  • Multidimensional Data Model
  • OLAP Solutions
  • Business Performance Management
  • Hyperion System 9 Overview
  • Hyperion Analytic Solution
  • Analytic Services
  • Analytic Administration Services
  • Life Cycle of the Essbase Analytics Database Design
  • Creating Essbase Analytics Applications and Databases
  • Creating and Managing Database Outlines
  • Creating Time, Accounts, and Scenario Dimensions
  • Creating Business-view Dimensions
  • Specifying Consolidation Operators and Defining Calculations
  • Setting Time Balance Properties
  • Creating Label-Only and Shared Members
  • Defining Duplicate Member Names and Member Aliases
  • Creating Attribute Dimensions
  • Data Load Options
  • Loading Data from Flat Files
  • Performing Free-Form Data Loads
  • Loading Data with Rules Files
  • Loading Data from SQL Data Sources
  • Outline Calculations
  • Calculation Scripts
  • Two-Pass Calculations
  • Dynamic Calculations
  • Dynamic Time Series
  • Smart View Overview
  • Connecting to the Analytic Server
  • Retrieving Multidimensional Data into Two-dimensional Spreadsheet Reports
  • Navigating Through Spreadsheet Reports
  • Manipulating Multidimensional Data
  • Installing the Web Server
  • Smart View Options
  • Updating Data on the Analytic Server
  • Creating Free-Form Reports
  • Selecting Members
  • Creating Reusable Queries
  • Extending the Spreadsheet Environment with Visual Explorer
  • Data Storage Options
  • Block Storage
  • Block Storage
  • Aggregate Storage
  • BI+ Architecture
  • Workspace Overview and User Interface
  • Browsing the Repository
  • Working with BI+ Content
  • Previewing Financial Reports
  • Grouping Financial Reports into Books
  • Web Analysis Overview
  • Viewing Web Analysis Documents in Workspace
  • Analyzing Query Results in Workspace
  • Creating Web Analysis Documents

Reviews