Hyperion Essbase Training | Hyperion Essbase Course Online

Hyperion Essbase Training | Hyperion Essbase Course Online



Oracle Hyperion Essbase Online training By real time experts with course material class videos real time scenarios  hands on practice Best institute for Hyperion Essbase online training in hyderabad USA India Chennai bangalore Pune Mumbai Noida Delhi UK UAE Australia Singapore Dubai Qatar.....



Oracle Hyperion Essbase Online Training Course Content



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