Oracle Hyperion Essbase
Oracle Essbase is an OLAP (Online Analytical Processing) Server that provides an environment for deploying pre-packaged applications or developing custom analytic and enterprise performance management applications. Oracle Essbase, along with Oracle BI Suite Enterprise Edition Plus, is part of the Oracle BI Foundation.
Objects:
- Essbase Overview
- Essbase Application Type
- Essbase Outline Terminology
- Dimensions and Dimension Types
- Attribute Dimension
- Alias and UDA Creation
- Member Properties and Dimension Properties
- Data Loading Process
Oracle Hyperion Essbase
Topic 1: Essbase Overview
- Introduction to Hyperion Essbase
- What is the requirement of Essbase?
- History of Essbase
- Hyperion Essbase Architecture
- Hyperion Essbase Versions
- Hyperion Essbase Clients
- Essbase Thin Client (EAS)
- Essbase Thick Client (EAS)
- Essbase Interaction Services-Introduction
- Essbase Studio-Introduction
- Excel Add-In (Spread Sheet Services)
- Smart View
- MaxL and ESSCMD
Topic 2: Essbase Application Type
- BSO Application
- Business Requirement of BSO App
- ASO Application
- Business Requirement of ASO App
Topic 3: Essbase Outline Terminology
- Data/Meta Data Explanation
- What is Essbase Outline?
Topic 4: Dimensions and Dimension Types
- What is Dimension?
- Standard Dimension
- Dense Dimension
- Sparse Dimension
- Account type Dimension
- Time type Dimension and DTS, TP Properties
- Currency Type Dimension
- Country Type Dimension
Topic 5: Attribute Dimension
- What is the need of Attribute Dimension?
Topic 6: Alias and UDA Creation
- What is the requirement of Alias and UDA's?
Topic 7: Member Properties and Dimension Properties
- Data Storage Properties
- Consolidation Properties
Topic 8: Outline building methods
- Generation Reference
- Level Reference
- Parent/Child Reference
Topic 9: Data Loading Process
- Data loading using flat files (.txt & .csv)
- Data loading using SQL
- Free Form Loading
Topic 10: Essbase Calculation Process
- Hierarchical Calculation
- Formulas
- Calculation Script
- Essbase Calculation Order
- Two-Pass Calculation
- Intelligent Calculation
Topic 11: Dense and Sparse restructure
- Restructure
- Implicit Restructure
- Outline Restructure
- Dense Restructure
- Sparse Restructure
- Explicit Restructure
Topic 12: Report Script
- Report Script
Topic 13: Essbase Partitions
- What is the requirement of Partitions?
- Partition Types
- Replicated Partition
- Transparent Partition
- Linked Partition
Topic 14: Essbase Optimization Techniques
- Outline Optimization
- Data load Optimization
- Calculation Script Optimization
- Database Optimization (Data Cache, Data File Cache, Index Cache, Dynamic Cache,
- Dynamic Calculator Cache)
Topic 15: Essbase MaxL and ESSCMD
- Automation of Essbase Jobs using ESSCMD Scripting
- Automation of Essbase Jobs using MaxL Scripting
- Topic 16: Essbase Analytics VS Enterprise Analytics
- BSO Advantages and Disadvantages
- ASO Advantages and Disadvantages
Topic 16: Security implementation
- Security Type
- EAS Security
- Shared Service Security
- Creation of Users
- Creation of Groups
- Creation of Essbase Filters
- Assigning users to groups
- Creation of Essbase Filters
- Assigning filters to groups
Topic 17: Introduction to Essbase EPMA App
- Introduction to dimension library
- Introduction to application library
Topic 18: Essbase Migration/Backups
Our distinct services include :
- Material and Documents: We provide real time working documents and materials to our students.
- Free System Access : We have the latest and most up to date platforms deployed on high-end servers that are available remotely and in-class on a 24/7 basis.
- Interview Preparation: We will prepare you for interviews in your specialized area by providing some real time interview questions. We also conduct mock interviews and assist you in preparing a professional resume.
- Placement Assistance: Our placement service division provides job placement support by submitting your resumes to prospective clients and emails you any new job opportunities in the market. However, we do not provide false guarantees on securing any jobs for you. We have a history of several ex-students who have secured excellent jobs based on our WORLD class training approach, implementation of case study projects and post training support.
- Initial Job Stabilization Support: We support our students to get stabilized in their job in the first TWO months. If our students come across any issues, we are there to help them. Students can send an email to us with their issues, our experts will reply back with possible solutions within 24 hours.
- Free Class Room sessions recording: In addition to the e-class training, we will give you authorization to record all of your e-class room training sessions, so that you can go back and review.
Other Courses related
Course registration
Instructor Led Hands-on eClassroom Training.
Key Points of Training Program :
Oracle Hyperion Essbase Courses, Learn with Online Practice, in-class Seminars, Training and Certification from the list of world-class education trainers. Macropus provides Class Material, Tutorial Curriculum, Demo Videos, Sample Questions, Recommended Books, Tips and Tricks. Get lectures and practical lessons on development and programming to improve technical skills and Students will benefit with Job Placements, Visa.