Categories
Uncategorized

Oracle Hyperion Essbase Online Training Course USA

Essbase Overview

  • 1. Introduction to Hyperion Essbase
  • What is the requirement of Essbase?
  • History Of Essbase
  • Hyperion Essbase Architecture
  • Hyperion Essbase Versions
  • Hyperion Essbase Clients
  • Essbase Thin Client
  • Essbase Thick Client
  • MaxL or ESSCMD
  • Essbase Interaction Services
  • Essbase Studio

2. Essbase Application Type

  • BSO Application
  • Business Requirement of BSO App
  • ASO Application
  • Business Requirement of ASO App

3. Essbase Outline Terminology

  • What is Essbase Outline?
  • Data/Meta Data Explanation

4. Dimensions and Dimension Types

  • What is Dimension?
  • Standard Dimension
  • Dense Dimension
  • Sparse Dimension
  • Attribute Dimension
  • Account type Dimension
  • Time type Dimension
  • Currency Type Dimension

5. Attribute Dimension

  • What is the need of Attribute Dimension?

6. Alias and UDA creation

  • What is the requirement of Alias and UDA’s?

7. Member properties and Dimension properties

  • Data Storage Properties
  • Consolidation Properties

8. Outline building methods

  • Data Load Overview
  • Generation Reference
  • Level Reference
  • Parent/Child Reference

9. Data Loading Process

  • Data loading using flat files
  • Data loading using SQL
  • Free Form Loading

10. Essbase Calculation Process

  • Aggregation
  • Formulas
  • Calculation Sript
  • Two-Pass Calculation
  • Intelligent Calculation

11. Dense and Sparse Restructure

  • Dense Restructure
  • Sparse Restructure

12. Essbase Partitions

  • What is the requirement of Partiton?
  • Replicated Partition
  • Transparent Partition
  • Linked Partition

13. Essbase Optimization Techniques

  • Outline Optimization
  • Dataload Optimization
  • Calculation Sript Optimization
  • Database Optimization

14. Essbase Maxl or ESSCMD

  • How to automate Essbase Application Creation Using MaxL?
  • How to automate Essbase Application Creation Using ESSCMD?

15. Essbase Analytics VS Enterprise Analytics

  • BSO Advantages and Disadvantages
  • ASO Advantages and Disadvantages

16. Security Implementation

  • Security Type
  • EAS Security
  • Shared Service Security
  • Creation of Users
  • Creation of Groups
  • Creation of Essbase Filters
  • Assigning users to groups
  • Creation of Essbase Filters
  • Assigning filters to groups

17. Real Time

  • Real time scenarios
  • Complexities faced in the implementation
  • Support Tickets or Real time Errors
  • Questionnaire
  • CV Preparation