Essbase Bootcamp

The objective of this five-day Essbase Bootcamp course is to empower students with the skills necessary to develop and successfully deploy their Essbase applications. Developed and taught by experienced Essbase consultants from an implementation perspective, this comprehensive course includes rigorous hands on exercises, real world advice, and step-by-step ’1-2-3′ implementation methods.

The Essbase Bootcamp course starts with the fundamentals of Essbase by walking students through the process of developing an application—starting with metadata design and outline mechanics, Smart View, automating loads and dimension builds with load rules, Essbase architecture, and calculation fundamentals. After building out the cube with Block Storage, we then show the fundamentals of working with Aggregate Storage and the primary differences with BSO. More advanced Essbase topics address fine-tuning applications, including the use of database partitioning through replicated and transparent partitions and advanced applied calculations. System Administration topics include automation with MaxL for deploying applications, security management, performance tuning, and configuration settings.

Whether the student is a more experienced developer or entirely new to the world of Essbase, this challenging course promises to empower the student with the tricks, tips and insights learned from our extensive Essbase implementation experience.

Upon completion of this course, students will be able to:

Build a cube in both BSO and ASO, have a good understanding of the architecture for both types of Essbase databases, and know how to write calculations for Block Storage and some basic MDX for ASO. They will have been given a framework for automating loads of data and metadata, how to move it to production by implementing security, and automating using MaxL.

Topics:

Overview of Essbase; Essbase Admin Console introduction

Building Outlines manually

Setting Dimension and member properties and best practices of design

Smart View Ad hoc

Load rules for Metadata updates; Load rules for loading Actual data

BSO Architecture – Dense/Sparse

ASO Architecture – Views; Building an ASO database and key differences with BSO