Process for Creating Custom-Defined Functions

To enhance the calculation functions provided with Essbase, you can create custom-defined functions for use in calculation scripts. Essbase does not provide sample custom-defined functions.

Custom-defined calculation functions are written in Java. Essbase does not provide tools for creating Java classes and archives; you must have a supported version of the JDK. See the Oracle Hyperion Enterprise Performance Management System Certification Matrix (http://www.oracle.com/technology/software/products/ias/files/fusion_certification.html).

For examples of custom-defined functions, see the Oracle Essbase Technical Reference.

  To create a custom-defined function:

  1. Review the requirements for custom-defined functions.

    See Custom-Defined Function Requirements.

  2. Write a public Java class that contains at least one public, static method to be used as a custom-defined function.

    See Creating and Compiling a Java Class.

  3. Install the Java class.

    See Installing Java Classes on Essbase Server.

  4. Register the custom-defined function as a local or global function.

    See Registering Custom-Defined Functions.