Hyperion Essbase Administration Server Architecture
Configuring Essbase Serve
Configuring Essbase Administration Console
Creating Essbase Analytic application and database
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.