What you'll learn
- Hyperion Essbase multidimensional database concepts
- Overview of Essbase Application Types (BSO - ASO )
- Sparse and Dense Dimensions
- Data storage properties (Store data - Dynamic calc)
- Understanding of Block and Block size
- Overview of data loads and optimization
- Siginificance of data block creation
- Data Load Rule using Essbase Administration Console
- Overview of MaxL
- Data retrieval using Smart view
- Calculation Scripts
- Managing Users and Groups
- Introduction to Essbase Paritions
- Introduction to MDX scripting
Requirements
- No Prerequisites
Description
This course would provide expertise on end to end implementation life cycle using Oracle's flagship multi-dimensional database called Essbase. It helps to understand the concepts of OLAP Applications, dimensions, hierarchies and data storage properties. Part of this course would also cover dimension build using rules files, sample data loads and aggregate the data. Explain the concepts of data block size, sparse and dense dimension properties, calculation scripts, report scripts, MaxL scripts and optimization techniques. Introduce to the Essbase Administration Services (EAS) Console and Smart View to retrieve the data from Essbase Applications.
Who this course is for:
- Students interested to learn Hyperion Essbase