Working with Functions

Functions define member formulas that return data values or members.

For example, you can use functions (and mathematical and logical operators) to return a list of siblings, parents, or children of a member you specify, to return a list of data values that are greater than or less than a value you specify, or to allocate data values from a member you specify. When you select a function, you are prompted to enter the correct parameters.

If you are working with Planning applications, you use functions in formula, script, condition, and member range components.

Following is a list of the types of functions you can use in Planning and Essbase block storage components. (See the Oracle Essbase Technical Reference for a complete list ,and descriptions of the functions.)

  • Boolean

  • Relationship

  • Calculation Operators

  • Control Flow

  • Data declarations

  • Functional

  • Mathematical

  • Member Set

  • Range (Financial)

  • Allocation

  • Forecasting

  • Statistical

  • Date & Time

  • Miscellaneous

  • Custom


Functions are available in the Member Selector and the Function Selector.

You use only Member Set functions in Essbase aggregate storage applications and components, including those used in Oracle General Ledger. (See the Oracle Essbase Technical Reference for a complete list and descriptions of the Member Set functions.)