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