Hyperion Essbase Online Training in Hyderabad

FEATURES OF SRYIT:

Course Duration: 60 Hours
Access: With 2 months server access
Trainer Details: 6+ Years Real Time Consultant
Prerequisites: Any Programming Language knowledge will be helpful. It is not compulsory Fresher’s also can learn this course.

Material: Soft Copy of Training Materials (sap abap material), Session Video Recordings will be provided of sessions provided.

After Training: Resume preparation, Interview Questions Career Support will be provided.

Support: 24/7 Customer Support

Contact us for more details and Session Schedules at

USA: +1-319-804-4998  India:+91-9948030675

Email: sryitsolutions@gmail.com

Web: http://www.sryitsolutions.com/

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 Script
•   Two-Pass Calculation
•   Intelligent Calculation

Dense and Sparse restructure

•   Dense Restructure
•   Sparse Restructure

Essbase Partitions

•   What is the requirement of Partition?
•   Partition Types

  Replicated Partition

•   Transparent Partition
•   Linked Partition

Essbase Optimization Techniques

•   Outline Optimization
•   Data load Optimization
•   Calculation Script 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