Hyperion Essbase Online Training And Certification Courses

Phone:+91 970 442 9989 (WhatsApp Also)
Email: [email protected]

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