You can extend the Essbase calculator language by creating and using custom-defined calculation functions and macros.
Note: | Custom-defined functions and macros do not apply to aggregate storage applications. |
Custom-defined functions enable you to create calculation functions that are not supported by the Essbase calculation scripting language. You develop custom-defined functions in Java, create custom-defined functions in Essbase, associate custom-defined functions with applications or Essbase Servers, and use custom-defined functions in formulas and calculation scripts (as you use native Essbase calculation functions).
For conceptual information about developing custom-defined calculation functions, see the Oracle Essbase Database Administrator's Guide. For examples, see the Oracle Essbase Technical Reference.
Custom-defined macros enable you to combine multiple Essbase functions into one function. Custom-defined macros can include macro functions, variables, and other macros. You can use macros in formulas and calculation scripts, as you use native Essbase calculation functions.
For conceptual information about developing custom-defined calculation macros, see the Oracle Essbase Database Administrator's Guide. For details about macro language syntax and rules and for examples of macro use, see the Oracle Essbase Technical Reference.