ESSBASE HYPERION ESSBASE ONLINE TRAINING | ESSBASE COURSE DETAILS | SRY IT SOLUTIONS

1
ESSBASE OVERVIEW

• www.sryitsolutions.com
• USA 1-319-804-4998 India91-9948030675
• Email id info_at_sryitsolutions.com

2
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

3
Essbase Application Type

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

4
Essbase Outline Terminology

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

5
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

6
Attribute Dimension

• What is the need of Attribute Dimension?
•   Alias and UDA Creation
•   What is the requirement of Alias and UDAs?

7
Member Properties and Dimension Properties

•   Data Storage Properties
•   Consolidation Properties

8
Outline building methods

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

11
Essbase Optimization Techniques

•   Outline Optimization
•   Data load Optimization
•   Calculation Script Optimization
•   Database Optimization

12
Security implementation

• Security Type
• EAS Security
• Shared Service Security
• Creation of Users
• Creation of Groups
• Creation of Essbase Filters

13
Offered Other Modules

• SAP SAP BPC, BASIS, ABAP,BO,ADMIN,FICO,MDM,CRM
  TRAINING,HANA TRAININGFSCM,IS UTILITIESBO DATA
  SERVICES, APO.
• DWH AB INITIO TRAINING,AJAX TRAINING,INFORMATICA
  TRAINING,DATA STAGE TRAINING, HANDOOP TRAINING,
  WEBSPHERE TRAINING.

14
Contact us for more details and Session Schedules
at USA 1-319-804-4998 India91-9948030675 Emai
l info_at_sryitsolutions.com Web
www.sryitsolutions.com