Oracle Hyperion Online Training

Oracle Hyperion Planning is a centralized, Microsoft Office and Web-based planning, budgeting and forecasting solution. Browse through the contents of the program.

Oracle Hyperion Course Contents
Schema Models
OLAP Models and brief explanation on ROLAP and MOLAP
Identification of Dimensions and Facts and create the Model to build cubes based on Real-Scenarios
Introduction to Hyperion Tools and Advantages
Essbase Architecture and Flow of Development Life Cycle of Essbase Cubes
Essbase Installation and Configuration Procedure
Essbase Terminology and Family Tree Relationships
Introduction of Database Design
Data Storage Properties
Time Balance and Expense Reporting Properties
UDAS, Attribute and Alternate Hierarchies
Introduction to ASO and BSO Options
Creating Essbase Applications and Databases
Understanding the Time, Scenario and Measures Dimension Concepts
Creating and building the dimensions rule files using Essbase Administration Services Console
Loading the data in Different Methods
Consolidation Operators
Duplicate Member Name Support
Creating Standard and Attribute Hierarchies
Creating Accounts Hierarchies
ETL Operations while Rule File Building
Dimensional and Data Loading using Interface tables and Flat Files
Dense and Sparse Concept, Block Structure
Data Storage Properties
Calculation Scripts
Hour-Glass Method Importance
Design and  Optimization Technique
Partitions and there types
ASO Physical Structure
Table space and Restructuring
MDX Scripts
Design and Optimization
Automation of Cube Loading using MaxL Scripts
Report Scripts
Introduction to Shared Services Console
Creating Users and Groups
Assign Cube and Filter Access to Groups
Essbase Config, Server and Application Log Files
Locks and Sessions
Backup and Recovery Methods
Introduction to Life Cycle Management and Usage
Accessing Cubes using Essbase Excel-Addin and generate Reports
Performing Adhoc Analysis using Smart View Tool
Various Options that is available in Essbase Excel-Addin and Smart-View Tools
Contact us today at or call us at +91-9100947004.