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

Aggregation of dimensions is the most common function embedded in calculation script (Hyperion Essbase) or business rules

Aggregation of dimensions is the most common function embedded in calculation script (Hyperion Essbase) or business rules (Hyperion Planning).

 

When designing properly and considering the other tips we have given, the fifth very important recommendation is a limitation of the aggregation function. The aggregation function is for instance used to perform the financial consolidation of data. When considering our performance optimization tip 4, it is never necessary to aggregate all dimension. Usage of the "CALC ALL;" statement should not be in your vocabulary. Repetition of aggregating dimensions should also be avoided if possible. If you use properly, the only command you need is the statement "AGG "

 

Think smart, design smart.

 

You will be able to save a lot of repetitive aggregation runs which will also have a negative impact on the fragmentation of your database.

 

This is one of several ways to optimize your Hyperion Planning or Essbase (BSO) cube.

 

Never forget that the functional interpretation is the most important. Understand what the client needs. The functional requirement translated into a proper design and solution is "key", the technical side is just a matter of experience and understanding how Essbase functions under the hood.

 

We have proved to be able to achieve optimizations up to 1000%. See a brief list of our achievements here.

© 2018 Top Dimension b.v.   T: +31 88 666 0000   E: info@topdimension.com
 
 
Tags: Strategic Planning: Dead Zone. Long Live Adaptive Planning, Best Wishes, Oracle Hyperion Essbase, Is there a difference between a dashboard and a scorecard?, Oracle Exalytics vs SAP Hana,
Meer »