Custom-Defined Calculation Functions


Overview

To get you started in creating custom-defined functions for the Analytic Services calculator, a set of example statistical functions is provided with this release. These examples are compiled and included in the essbase.jar file, located in the ARBORPATH\java\ directory.

For information about creating custom-defined functions, see the the MaxL DDL create function statement. For more information about custom-defined functions, see the Database Administrator's Guide.

Java Code Examples

The Java code for examples of custom-defined functions is provided in the file statisti.jav, located in the following directory of your Analytic Services installation: docs\techref\maxl\cdf\examples. This file can be viewed in any text editor. For more information about the classes, methods, and constants in the statisti.jav file, see the documentation for the Statistics Java package.

The code contained in the statisti.jav file is implemented in the ARBORPATH\java\essbase.jar file. The examples in the statisti.jav file use constants which are defined in the essbase.jar file. To use the constants defined in these examples, you must import the Calculator class constants defined in the essbase.jar file.

MaxL Registration Scripts

Sample scripts for registering and dropping the example custom-defined functions are provided in the following files, located in the following directory of your Analytic Services installation: docs\techref\maxl\cdf\examples.

register.mxl - to register the functions locally in an application. View as HTML
drop.mxl - to drop the functions (if they were registered locally). View as HTML
reglobal.mxl - to register the functions globally. View as HTML

The sample files can be viewed or modified in any text editor. For more information about registering custom-defined functions, see the Database Administrator's Guide.

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com