Training in Chennai offers best Oracle Essbase Training in Chennai with most experienced professionals. Our Instructors are working in Oracle Essbase and related technologies for more years in MNC’s. We aware of industry needs and we are offering Oracle Essbase Training in Chennai in more practical way. We framed our syllabus to match with the real world requirements for both beginner level to advanced level. Our training will be handled in either weekday or weekend’s program depends on participant’s requirement. We do offer Fast-Track Oracle Essbase Training in Chennai and One-to-One Oracle Essbase Training in Chennai. Here are the major topics we cover under this Oracle Essbase course Syllabus Overview of Oracle Essbase, Smart View, Essbase Application Creation Fundamentals, Aggregate Storage Databases, Block Storage Databases, Describe how data blocks are indexed, Essbase Administration, Essbase Studio. Every topic will be covered in mostly practical way with examples.

• Data Warehouse Concepts
• Business Intelligence
• Data warehouse
• Business Requirement gathering
• 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.

Course Duration:  2  to  3 Month, 2 hpd

Contact:  +91  9080334727

Mail:  info@velgrotechnologies.com