Working with Functions

If you are working with Financial Management, Planning, and Essbase block storage applications, you use functions in formula, script, condition, and member range components; if you are working with Essbase aggregate storage applications, including those used in Oracle General Ledger, you use functions in Point of View components only.

You use functions to 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.

The functions you can use in calculations are different for Financial Management, Planning, and Essbase applications.

Following is a list of the types of functions you can use in Financial Management components. Financial Management functions are categorized according to the types of rules in which they can be used. (See the Oracle Hyperion Financial Management Administrator’s Guide for a complete list, and descriptions, of the functions you can use in components in Financial Management applications.)

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

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