Hyperian Essbase Online Training

Hyperian Essbase Online Course content

What is Hyperian Essbase?

 Constructed on real-time methodical infrastructure, Essbase offers EPM and BI users the capability of quickly dissecting as well as analyzing data using perceptive interface. The end-users of Essbase have various options to interact with the data including Hyperion Financial Reporting, Microsoft Excel, as well as Hyperion Web Analysis. With bringing Essbase alongside other applications, users can find lane support for the persistent business needs.

  • DATA WAREHOUSE CONCEPTS
  • Business Intelligence
  • Data & Metadata
  • Dimensional Table
  • Fact Table
  • Factless table
  • Slowly changed Dimensions
  • Confirmed Dimensions
  • Write-back
  • Data warehouse
  • Data mart
  • Business Requirement gathering
  • Star Schema Design
  • MDDB
  • OLAP vs. OLTP
  • Snow flake Schema
  • Normalization Vs Renormalization
  • HYPERION ESSBASE 11.x
  • 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
  • Hyperion Analytic Solutions
  • Hyperion Architecture
  • Hyperion Essbase Architecture
  • Hyperion Essbase Analytical Architecture
  • Hyperion Essbase Administration Server Architecture
  • Configuring Essbase Serve
  • Configuring Essbase Administration Console
  • Creating Essbase Analytic application and database
  • Members
  • 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 dimens
  • 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)
  • 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
  • Register Today to Attend Free Demo Session @ + 91 8790679998

Contact Information ;
SKYPE ID: adithyaelearning
Contact : +91 8790679998, 9848371343
EMAIL : adithyaelearning@gmail.com , info@adithyaelearning.com