Oracle Hyperion Essbase Online Training

We are going to provide training on the latest version of Essbase which will be provided by real time Consultant. In these workshops not only basic training, project training also will be provided without extra cost. We will distribute the questionnaire for which student has to prepare the answers which will be discussed in the class room. By the end of our training sessions we will ensure that Jobseeker will attend the interview confidently. There is a special offer with Essbase & Planning Course. We will prepare resume with real time clients. BI Analytic Solutions is deeply committed to your success. We respect your time and money. We Will Provide Both Online & Class Room Training

Hyperion Essbase Training Content

Essbase Overview

• 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
    
  • Excel Add-In
    

Essbase Application Type

• BSO Application
  

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

• ASO Application
  

Essbase Outline Terminology

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

Dimensions and Dimension Types

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

Attribute Dimension

• What is the need of Attribute Dimension?
  

Alias and UDA Creation

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

Member Properties and Dimension Properties

• Data Storage Properties
  
• Consolidation Properties
  

Outline building methods

• Generation Reference
  
• Level Reference
  
• Parent/Child Reference
  

Data Loading Process

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

Essbase Calculation Process

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

Dense and Sparse restructure

• Dense Restructure
  
• Sparse Restructure
  

Essbase Partitions

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

Essbase Optimization Techniques

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

Essbase MaxL or ESSCMD

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

Essbase Analytics VS Enterprise Analytics

• BSO Advantages and Disadvantages
  
• ASO Advantages and Disadvantages
  

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
  

Real Time/Project Training
Real time scenarios
Complexities faced in the implementation
Support Tickets or Real time Errors
Questionnaire
CV Preparation