Brochure
Enquire
- Introduction of Data-Warehousing Concepts
- OLAP Models and brief explanation on ROLAP and MOLAP
- Introduction to Hyperion Tools and Advantages
- Essbase Architecture and Flow of Development Life Cycle of Essbase Cubes
- Home
- Mindmajix Technologies
- Courses
- Hyperion Essbase Training
Quick Facts
| particular | details | ||||
|---|---|---|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study, Virtual Classroom
|
Mode of Delivery
Video and Text Based
|
Frequency of Classes
Weekdays, Weekends
|
Course and certificate fees
certificate availability
Yes
certificate providing authority
Mindmajix Technologies
The syllabus
Data Warehousing Concepts
Essbase Storage Properties
- Essbase Terminology and Family Tree Relationships Introduction of Database Design
- Data Storage Properties
- Time Balance and Expense Reporting Properties UDAS, Attribute and Alternate Hierarchies
- Introduction to ASO and BSO Options
- Creating Essbase Applications and Databases
- Understanding the Time, Scenario and Measures Dimension Concepts
- Creating and building the dimensions rule files using Essbase Administration Services Console
- Loading the data in Different Methods
- Consolidation Operators Duplicate Member Name Support
Essbase Cube Implementation from Scratch
- Creating Standard and Attribute Hierarchies
- Creating Accounts Hierarchies
- ETL Operations while Rule File Building
- Dimensional and Data Loading using Interface tables and Flat Files
BSO Cube Implementation
- Dense and Sparse Concept, Block Structure
- Data Storage Properties
- Calculation Scripts
- Hour-Glass Method Importance
- Design and Optimization Technique
- Partitions and there types
ASO Cube
- Implementation Aggregations
- ASO Physical Structure
- Tablespace and Restructuring MDX Scripts
- Design and Optimization
Scripts
- Automation of Cube Loading using MaxL Scripts
- Report Scripts
Security and Administration
- Introduction to Shared Services Console
- Creating Users and Groups
- Assign Cube and Filter Access to Groups
- Essbase Config, Server and Application Log Files
- Locks and Sessions
- Backup and Recovery Methods
- Introduction to Life Cycle Management and Usage
Introduction to Excel-Addin and Smart View
- Accessing Cubes using Essbase Excel-Addin and generate Reports Performing
- Adhoc Analysis using Smart View Tool
- Various Options that are available in Essbase Excel-Addin and Smart-View Tools
Articles
Popular Articles
prev
next
