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
Note:
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.)