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

Hyperion Planning Online Training | Hyperion Planning Self Learning

Hyperion Planning Online Training | Hyperion Planning Self Learning



Oracle hyperion Planning Online Training by real time experts with course material server access for practice job assistance support hyderabad chennai bangalore pune mumbai noida delhi india usa uk australia uae singapore dubai qatar...



Oracle Hyperion Planning and Budgeting Online Training 



1.Essbase Overview


  • Introduction to Hyperion
  • Introduction to Hyperion Planning
  • Hyperion Planning Architecture
  • RDBMS/Planning/Essbase
  • Hyperion Essbase Terminology
  • Navigating the Planning Web Client
  • Hyperion Workspace
2. Planning Dimensions and Data Storage Overview


  • Planning Dimensions Overview
  • Required Dimensions
  • User-Defined Dimensions
  • Dense Dimensions
  • Sparse Dimensions
  • Data Block Creation Process
  • Selecting Aggregation, Data Storage, And Calculation Options
3.Planning Application Creation


  • Classic Planning Application Creation
  • Pre-requisites to create Hyperion Planning Application
  • Oracle Schema Creation
  • Data Source Creation
  • Year and Timeperiod Setting
  • Currency Settings
  • Defining Plan Types
  • EPMA Planning Application Creation
  • Pre-requisites to create Hyperion Planning Application
  • Oracle Schema Creation
  • Data Source Creation
  • Dimension Library Creation Process
  • Year and Time period Settings
  • Currency Settings
  • Defining Plan Types
4. Loading metadata from File


  • Metadata building in Classic Planning Application
  • Metadata Creation Process
  • Manual Process (for learning purpose)
  • Loading Metadata into Planning Application using outline load utility
  • Metadata building in EPMA Planning Application
  • Metadata Creation Process
  • Manual Process (for learning purpose)
  • Loading Metadata into EPMA Planning Application using .ads flat files
5.Creating and Managing Web Forms


  • Creation of Simple Web Forms
  • Creation of Composite Web Forms
  • Creation of Web Form Folder Structure
  • Assigning BR to the Web Forms
  • Security on Web Forms
  • Security on Web Forms Folder Structure
6.Data Submission Process


  • Entering Data using Web Forms
  • Entering Data uisng Smart View
7.Creating Business Rules


  • Overview on Business Rules
  • Business Rules Creation Process
  • Using Run-Time Prompts in Business Rules
  • Defining Access Privileges to Business Rules
8. Creation of Smart Lists


  • Smart List Creation
9. Creation of Task Lists


  • Creation of Task Lists
  • Defining Access Privileges to Task Lists
10. Process Management Overview


  • Work Flow
11. Security Implementation


  • Hyperion Shared Services
  • Creation of Users
  • Creation of Groups
  • Assigning users to groups
  • Giving Access to Planning Application
  • Giving Security on Dimension Members
  • Giving Security on Business Rules
  • Giving Security on Task Lists
12. Real Time



  • Real time scenarios
  • Complexities faced in the implementation
  • Support Tickets or Real time Errors
  • Questionnaire
  • CV Preparation