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: Shurgard: What's our future reporting landscape look like?, CFO Strategic Planning facilitated by our Cockpit, Oracle Hyperion Financial Management (HFM) part of a software selection? A question list to help you challenge the vendor, The Stacked Discount Case, Optimisation Hyperion Planning and Essbase Tip 4,
Meer »