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

What my Client's Say?

 

  • Prabhu is an excellent instructor, very patient and thorough. I have tried another training class and EXPLORE IT far exceeds other trainers and their methods ~ Hassan Malik

  • An extremely helpful and informative course. Training materials were well organized and provided good case studies. Instructor was extremely professional and pleasant to learn from.~ Bhavani Sudarshnam

  • The training was clear and detailed. I like Parker's style of teaching as the recurrent training is a thorough review of the HR. Every opportunity for the student to ask questions was provided. ~ Yiting Chen

  • Jane Anderson conducted the class in a very professional manner. Examples were very relevant and I feel that I gained a lot from the updated materials this year.~ Somesh Taneja

  • Prem was a great instructor. Thanks Prem for making the training easy to understand. A lot of information was covered. He made the approach easy to follow.~ Komali Sambakula

  • She wants to make sure that her students walk away from her course with a good working knowledge. She is an excellent trainer and cares that all of her students learn the material.~ Kiran Jain

  • Krishna is very thorough and professional. He made the code very understandable. I was very impressed with his teaching methods and presentation of the regulations. EXPLORE IT is the best! ~ Rajesh Isukapalli

  • Mr. Chris Brown was very affirmative with the course, on time and fluent. This is my second recourse with him. I hope to take his course as long as I am shipping at my current job. ~ Awais Rahim