Your partner in performance management
Top 10 Performance Optimization Hyperion Planning/Essbase
Home » Optimisation Hyperion Planning and Essbase Tip 1

Performance Hyperion Planning and Essbase

There are several ways to optimize your Hyperion Planning or Essbase (BSO) cube. Presuming the functional interpretation is 100% translated into a proper design, the technical side remains.


When talking about the technique, the far best winning optimization is choosing the proper dense and sparse settings of the Essbase cube, followed by the appropriate order of dimensions. This is in our practise the most effective performance optimization.


A data block size of approximately 40 Kb is probably the best. Don't follow the Oracle Hyperion database admin guide on this and 64 bits, as a replacement of 32 bits environments nowadays, won't bring as you might expect. The fundamental design and appropriate data block sizes of the outline with its dense and sparse settings is still key in a high performing solution.


Keep in mind this goes along with other optimizations to reach significant effects varying from approximately 100%-1000% of performance gain.


See a brief list of achievements here.

© 2022 Top Dimension b.v.   T: +31 88 666 0000   E: [email protected]
Tags: Optimisation Hyperion Planning and Essbase Tip 1, Gartner Magic Quadrant: EPM Market Leaders, Shurgard: What's our future reporting landscape look like?, Strategic Planning is not a military discipline anymore: welcome Adaptive Planning, Successful EPM solution delivery: don't forget the blind side,
Meer »