mail info@ascendinfosolutions.com    phn 732- 645-7910

HADOOP-BIGDATA

HYPERION

  • ESSBASE 11.x

 

DATA WAREHOUSE CONCEPTS

  • Business Intelligence
  • Data warehouse
  • Data mart
  • Business Requirement gathering
  • Star Schema Design
  • MDDB
  • OLAP vs. OLTP
  • Snow flake Schema
  • Normalization Vs Renormalization
  • Data & Metadata
  • Dimensional Table
  • Fact Table
  • Factless table
  • Slowly changed Dimensions
  • Confirmed Dimensions
  • Write-back

 

HYPERION ESSBASE 11.x

  • 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
  • Memmbers
  • Member Properties
      • Consolidation Properties
      • Storage Properties
  • Time balance properties
  • 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
  • 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 dimensions
    • Database optimization using Data settings.