Oracle

Improve Your Essbase Calculation Capability

The Essbase Block Storage (BSO) database is a powerful calculation engine capable of executing oodles of formulae with very few lines of code. But there’s a catch. You need to learn how to do it right.

A poorly written calculation in an Essbase BSO cube can yield some pretty spectacular results.  Here are a few examples that I have seen:

  • An individual wrote a calculation script to seed a forecast with actual data. The author omitted reference to the year and completely overwrote all historical years in the forecast with actual data.
  • A poorly written calculation script kept running until the Essbase server ran out of disk space.
  • An inexperienced developer wrote a very complex calculation script that yielded correct data but took days to run.
Oracle - Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud
Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud

Explore key considerations, integrating the cloud with legacy applications and challenges of current cloud implementations.

Get the Guide

Some people can learn to avoid mistakes like these by reading and study. Others need mentoring or a classroom setting. On June 13th I’ll be teaching the two-day Oracle Essbase 11.1.2 Calculate Block Storage Databases class at our education facility in Houston, Texas.  This Oracle University course is a great way to see some of these types of mistakes in action as well as learn how to avoid them. You’ll also learn:

  • Some great methods for improving performance of your existing calculations.
  • The calculation development life cycle.
  • Calculation script design principles.
  • How to use AGGMISSG, UPDATECALC, and CALCCACHE to optimize calculation performance.
  • And a bunch more…

Instruction from the Essbase Calculation Block Storage Databases course applies to anyone developing calculations directly in Essbase or those developing business rules for Hyperion Planning.

Click here if you want to know more about Oracle Training at Perficient.

About the Author

Cris Dunn is the manager of Perficient's EPM SupportNet practice which provides direct support for applications and infrastructure surrounding many organizations' EPM software implementations. He is also an Oracle University certified instructor and teaches everything around Essbase as well as the EPM installation and configuration classes. When he is not working, you will find Cris engaged in His church serving as the treasurer, musician, nursery worker, and, when necessary, toilet scrubber.

More from this Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up
Categories