HYPERION ESSBASE Online Training

HYPERION ESSBASE Training Overview
Introdution

1. Hyperion Analytic Solutions
2. Hyperion Architecture
3. Hyperion Essbase Architecture
4. Hyperion Essbase Analytical Architecture
5. Hyperion Essbase Administration Server Architecture
6. Configuring Essbase Serve
7. Configuring Essbase Administration Console
8. Creating Essbase Analytic application and database
9. Explanation of Essbase components like Database Outline, calc script, Rule File & report Script.
   Dimensions
   • Standard Dimensions
   • Attribute Dimensions
   • Dense & Sparse Dimensions
   Dimension Properties
   • Dimensions Type Properties
   • Storage Properties
   Members
   • Member Properties
   • Consolidation Properties
   • Storage Properties
   • Time balance properties
   • Variance Expenses
   • Skip Options
   • Dynamic Time Series (DTS members)
   Building Outline
   • UsingManually
   • Using rule file with dynamic dimension build methods
   User Defined Attributes (UDA’S)
   • Building manually, dynamic dimension build methods using rule file
   Shared members
   • Building manually, dynamic dimension build methods using rule file
   Two-pass
   Building Dimensions using Rule file with dynamic Dimension Build Methods
   • Generation Reference
   • Level Reference
   • Parent/Child Reference
   Loading Data into Outline With Rule (with realtime Scenarios)
   Loading Data into Outline Without Rule file (freedom Data Loading)
   Types of Free form data loading
   • Loading data from excel
   • Loading data using import from export data file
   Explanation Excel Add-in recover
   Building Reports with Excel Add-in
   Creating Formulas with real time scenarios
   Creating Calc Script (simple to Complex real Examples)
   Building Reports with Report scripts
   ESSCMD & Maxl
   Interactive.
   Batch process
   Differences between BSO & ASO
   Outline back & Recovery
   Data Backup & Recovery
   Creating Users / Groups
   Creating Filters
   Optimization Techniques
   Outline Optimization
   • Data load Optimization
   • Calc Script Optimization
   • Database optimization using Attribute dimensions
   • Database optimization using Data settings.