toggle menu

Hyperion Essbase Online Training

  1. Velocity Infosystems ›
  2. Hyperion Essbase Online Training

Hyperion Essbase Online Training

Hyperion Essbase Online Training
Hyperion Essbase Online Training

Hyperion Essbase Online Training Course Content :

  • DATA WAREHOUSE CONCEPTS
  • Business Intelligence
  • Data warehouse
  • Business Requirement gathering
  • Star Schema Design
  • MDDB
  • OLAP vs. OLTP
  • Data & Metadata
  • Dimensional Table
  • Fact Table
  • HYPERION ESSBASE 11.x
  • 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
    • 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
  • 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 ptimization using Attribute dimensions
    • Database optimization using Data settings.

Drop your query

Most Popular Courses

Achieve your career goal with industry recognised learning paths

What my Client's Say?

 

  • It was a great course over my expectations. I am eager to have another course wıth you as soon as possıble ~ R. Kamand

  • All in all, it was a very constructive and one in a lifetime experience. I'm so glad that I was part of it.~ T. Engin

  • It was the best decision I had ever made in my life. Although it was expensive for me, but I don't regret even for one second. ~ Maruti Malla

  • Thank you for this great course. I learned a lot of things, I met very nice people and I am happy that I had these 6 crazy weeks with you.".~ Najmul Shar A Baig

  • Very nice and friendly tutor and staff. The course was very fruitful, particularly the input sessions during the first half of it.~ Radha Nandyala

  • It was such great experience, though it was really intensive, it was worth doing it! Cant thank enough all team effort esp Mohan! .~ Rohan Kumar

  • The course was really good because it was a practical course.~ M.Radha patel

  • I liked this experience. Good tutor and nice mates. I will always remember it. ~ Jitu Bavaria

Request a Call Back