Oracle Essbase (11g On Premise): Bootcamp Training Course


5 days (35 CPE credits)


Implementation consultants, developers, system administrators 

Course Summary

Learn about the design of Essbase Block Storage (BSO) and Aggregate Storage (ASO) databases. Understand Essbase multidimensionality, the loading and manipulation of data through calculation scripts and how to maintain and optimise Essbase databases.

How Can I Take this Course? 

You can search for scheduled course dates for your time zone or you can request a private class for your team:

Oracle Essbase on premise bootcamp training course private class.
Course agenda for the Keyteach Oracle Essbase 11g on Premise bootcamp training course

Learning Objectives

By the end of this course learners will be able to:

  • Identify the key differences between ASO and BSO databases
  • Explain how to import existing metadata and configure enhanced reporting capabilities
  • Critique how Essbase databases can be optimised
  • Recognize the various methods for loading and entering data to the system
  • Generate basic reports, spreadsheets and dashboards for entering and reviewing data
  • Implement calculation scripts to perform targeted calculations

Course Description

This course covers everything you'll need to know to design and maintain Essbase Block Storage (BSO) and Aggregate Storage (ASO) databases. No prior knowledge is assumed. Learn the primary methods for the design of Essbase block storage databases.

Understand Essbase multidimensionality, dense and sparse settings, building outlines with load rules, maintaining the Essbase environment, creation and calculation of data blocks, storage types, dynamic calc shared members, the order of operations, member formulas, dynamic calculations, two-pass calcs and sparse rollups.

The course also covers detailed information about database outlines, loading data and analysis within a spreadsheet environment. There's also focus on the creation and optimisation of calculation scripts and the backup and system administration of the system.

Scheduled Course Dates

There are currently no scheduled courses. Please use the link below to request a private closed class for your team.

private horizontal

NASBA CPERegistry logo blue transparent

Course title: Oracle Essbase (On Premise): Bootcamp

Duration: 5 days

Audience: System administrators, developers and implementation consultants

Pre-requisites: None

Delivery method: Group Live and Group Internet-Based

Advanced preparation: None

Recommended CPE credits: 35 credits - computer software and applications

Programme level: Intermediate

Keyteach is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. Registration ID No 115820. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Any complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:

Connect with us

3 Station View
Rhino Court Business Park, Hazel Grove
Stockport, Cheshire, United Kingdom, SK7 5ER

  • USA +1 855 563 6723

  • UK +44 161 408 7722


Enter your email and we'll send you more information

© Copyright Keyteach Ltd 2023


UK +44 161 408 7722
USA +1 855 563 6723