Why I created a blog

Its been many years since I first created this blog. It has remained true to Essbase and related information over those years. Hopefully it has answered questions and given you insight over those years. I will continue to provide my observations and comments on the ever changing world of EPM. Don't be surprised if the scope of the blog changes and brings in other Hyperion topics.

Thursday, May 16, 2019

Is Hybrid worth it?

I was recently at a client who is migrating to OAC.   We brought one of their applications into OAC. It is a BSO application. On-Prem the run some currency calculations and then aggregate the cube. The resulting cube is about 300gig and takes over 4 hours to calculate.  They hate to make changes as they take so long.

So, I suggested we look at making it hybrid. They can still run their calculations and gain the speed of not having to do aggregations.
For our test, first we loaded data into the non-hybrid cube in OAC and just ran the aggregation calculation.   After 3 hours, it had filled the disk, the calculation failed and we had to clear the data (Not sure why the disk filled, we are talking with Oracle about that)
So for my Hybrid version, I took all of the sparse dimensions and make them dynamic, not that I needed it, but I also set the HYbridBSOInCalcScript  FULL. We loaded the same data file and tried to retrieve from Smart view with some large retrieval templates they use on-prem. Retrieval time was ok, but not stellar. Their largest sheet that takes about 20 seconds on-prem took about a minute to refresh.
They were ok with that, but I was not.  Looking at their outline and the retrievals, I discovered one dimension that is 17 levels deep that is used at the top two or three generations in a lot of reporting. On a whim, I changed that dimension back to stored and wrote a calculation script to just aggregate that one dimension, fixing on level 0 of all of the other dimensions.  That aggregation took 27 seconds.  When we refreshed the excel reports, the time was about the same as on-prem, maybe a little faster.

Since then, they have  run a number of other calculations, make adjustments in the cube and are no longer fearful of kicking off a calculation.

Is Hybrid worth it. I think they would say YES

No comments: