Guide: To implementing Essbase Custom-Defined Functions

In How To Guides, Link by donhagell

Many times when developing Essbase calculations or Hyperion Planning Business Rules, the out-of-box functions provided are useful for providing static type calculations based on conditional logic.  This is good for creating rich analytic applications with simple logic and mathematics that can accurately represent the data.  When it comes to complex calculations with dynamically changing conditions or using iterative methods, an Essbase CDF is the solution.  Extending Essbase calculation scripts to include custom functions can add a layer of analytic or forecasting metrics to existing legacy financial data.  A CDF could also be used to update existing data from web services for example, currency rates in a Planning application.  CDF’s are a great solution for integrating into existing Planning, Budgeting and Forecasting Cloud Services (PBCS).

Essbase contains a rich function set for building calculation scripts; however the calculations can be extended to include any number or type of computations or algorithms.  This Guide will review the basic steps to get started.  Other more detailed guides may follow on implementing additional specific application examples.

Applications of the CDF:
•    Goal Seeking
•    Dynamic outline building
•    Time Encoding/Decoding
•    Live Data Feed
•    Computational Algorithms and Methods
•    Integration with Essbase API.
•    Integration with other languages and protocols such as R script, Jython, Python, Ruby, and Email.
•    Anonymous Lambda Functions for dynamic programming
•    Anything else that Essbase can’t do easily
•    Built with Java so the potential is unlimited.