HYPERION ESSBASE

  • 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.