1. Designer's Guide
  2. Using Member Selection, Variables, Functions, Smart Lists, and Planning Formula Expressions to Design Components
  3. Working with Functions
  4. About Functions

About 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 Oracle Hyperion Financial Management, Oracle Hyperion Planning, and Oracle 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.

The functions you can use in calculations are different for Financial Management, Planning, Oracle General Ledger, 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.)

  • Calculation

  • Translation

  • Consolidation

  • Allocation

  • Dynamic Calculation

  • Transactions

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