Hyperion Oracle Online for advanced learners by SR Info Solutions

HYPERION ESSBASE

HYPERION ESSBASE

Hyperion Analytic Solutions
Hyperion Architecture
Hyperion Essbase Architecture
Hyperion Essbase Analytical Architecture
Hyperion Essbase Administration Server Architecture
Configuring Essbase Server

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
Using Manually
Using rule file with dynamic dimension build methods
User Defined Attributes (UDAS)
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)
Maxl
Differences between BSO & ASO
Outline back & Recovery
Data Backup & Recovery
Creating Users / Groups
Creating Filters
Migration process
Partitions
Optimization Techniques
Outline Optimization
Data load Optimization
Calc Script Optimization
Database optimization using Attribute dimensions
Database optimization using Data settings.