You are here: Home Oracle Essbase Courses Essbase: Bootcamp BSO (5 days)

Essbase: Bootcamp BSO (5 days)

Essbase: Bootcamp BSO (5 days)

Audience:  Essbase Developers and Hyperion Planning Administrators

Learning Objectives

Learn about the design of Essbase block storage databases and gain an understanding of Essbase multidimensionality, the loading and manipulation of data through calculation scripts and how to maintain and optimise Essbase databases.

Course Description

This course covers everything you will need to know in order to design and maintain Essbase Block Storage (BSO) 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. Focus is also given to the creation and optimisation of calculation scripts and the backup and system administration of the system.

Day Summarypdf detailed agenda

Day 1: Overview, Navigation, Outline creation and Dimension loading
Day 2: Enhanced reporting capabilities, data loading and Spreadsheet analysis
Day 3: Essbase optimisation, task automation and security
Day 4: Calculation methodologies and calculation scope control
Day 5: Relationship, mathematical and range calculations

Scheduled Course Dates

Register: Scheduled Course Dates - Select Course Title to Register


13 Oct 2014 - 17 Oct 2014
Price: £ 3100.00

20 Oct 2014 - 24 Oct 2014
Price: 30000.00 SEK

CPE Credits (North America)CPE Sponsors

Essbase Bootcamp BSO
5 days
Essbase Developers and Hyperion Planning Administrators
Delivery Method:
Classroom (Group-Live)
Advanced Preparation: 
Recommended CPE Credits: 
35 Credits -Specialized Knowledge and Applications
Programme Level: 

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: 

Onsite Training at Your Premises

We can arrange dedicated training at your premises or at 3rd party locations on dates to fit with your project deadlines.

In addition to our published schedule of courses, we can also bring the classroom to your premises, delivering a
combination of administrator courses to meet your exact requirements or the customised delivery of end user
training to match your application and business processes. Onsite courses tend to be cost effective with four or
more attendees.

You will need to provide a room with a data projector, we will ship pre-configured laptops and courseware including the 
manuals, pads, pens and an instructor!  As an alternative to shipping laptops we can provide access to cloud-based 
configured hardware over the internet if required.

Use the following link to request onsite training:

>> Make contact with Keyteach