Essbase – Page 2 – Impact EPM

What Breed of Essbase to choose – BSO – ASO – Hybrid

By Nic | July 3, 2024

Building a new Oracle EPM Planning application? Or is your old one not working too well?. Either way you’ve got to get the engine room right! The variant of Essbase makes a difference to the user experience on performance.

In the days before EPM Planning SaaS, to get better performance out of the system you could either upgrade the hardware or optimise the software. Now that Oracle has taken control of the hardware in EPM Planning SaaS, there’s only one option left, optimise the software. Within your application the first thing to consider is the choice of Essbase for your use case. So which one do you choose?

This article explores and compares the performance of Block Storage Option(BSO); Aggregate Storage Option(ASO) and the Hybrid, a combination of BSO and ASO and shines a light on what you may want to use.

Optimising Cost Allocations in Hybrid Essbase

By Nic | June 16, 2024

How good is the Oracle EPM Hybrid Essbase for doing cost allocations? Surely it would be hampered by having to keep recalculating the total cost dynamically every time the allocation formula ran, i.e. 1000’s times to the members that you want to allocate to.

In this post I look at using an ARRAY and other options within a calculation script, leverage the power of Groovy in a combined Calculation/Groovy script and evaluate a total Groovy option in Hybrid and ASO. I uncover what doesn’t really work at all, how a basic allocation performs, and how to optimise the allocation to take the calculation time from minutes down to a few seconds, all with working code examples from my test application.