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.

© 2018 Top Dimension b.v.   T: +31 88 666 0000   E: info@topdimension.com
 
 
Tags: Strategic Planning is not a military discipline anymore: welcome Adaptive Planning, 11.1.2.3 Hyperion Business Planning, Optimisation Hyperion Planning and Essbase Tip 7, Optimisation Hyperion Planning and Essbase Tip 3, Best Wishes,
Meer »