You use the New Function dialog box to create a custom-defined function on the Essbase Server instance that is identified in the Essbase Server box.
Note: | To edit a function on a different Essbase Server instance, in Enterprise View, under the preferred server, double-click the Functions node. |
Only functions developed in Java can be created in Essbase. Custom-defined functions require Java Runtime Environment, which is installed as an option with Essbase.
To create a function, you enter information in the following text boxes:
Scope—An application name (for local functions) or <all apps> (for global functions)
Name—For example, @JSUM
For information about length limitations and naming conventions, see the Oracle Essbase Database Administrator's Guide.
Class—Name of the full Java class used to develop the function
For example, the following compiled Java class might be archived in a .jar file: com.hyperion.essbase.calculator.Statistics 1, where Statistics.java was compiled into Statistics.class and the class was archived ascom/hyperion/essbase.calculator/Statistics.class.)
Method—Java class method associated with the function
For example, the covariance element of com.hyperion.essbase.calculator.Statistics.covariance identifies a method.
Spec—The Essbase calculator-syntax specification string (optional); for example, @COVARIANCE (expList1, expList2)
To use the output string of the EssListCalcFunctions API function to return the current function, you must use a specification string. If you do not use a specification string, you cannot enter a comment.
Comment—A description (optional and possible only if a specification string is used)
You can select the Runtime option and, thereby, designate the current function as a runtime function. However, you should select Runtime only in special circumstances, as the Runtime property can seriously affect performance.
create function (MaxL) in the Oracle Essbase Technical Reference
display function (MaxL) in the Oracle Essbase Technical Reference