About Member Selection, Variables, Functions, and (for Planning Users Only) Smart Lists

Like you use components to design business rules, you use members, variables, and functions to design components.

You use member selection in formula, script, condition, member and data range, and member block components to select members and functions that return a list of members (for Planning and Essbase applications) or members and member lists (for Financial Management applications). See Working with Members.

You use variables to build formulas for formula, loop, and condition components. There are two types of variables: execution variables, which are calculated when the business rule is launched, and replacement variables, which are substituted for more complex formulas or functions. (See Working with Variables.) You can create these types of variables:

Functions are predefined formulas that you can use in loop, condition, and formula components. The functions you can use in components differ for Financial Management, Planning, and Essbase applications. (See Working with Functions for descriptions of the function types available for Financial Management, Planning, and Essbase applications. See the Oracle Hyperion Financial Management Administrator’s Guide for a complete list, and descriptions of, the functions you can use in Financial Management components. See the Oracle Essbase Technical Reference for a complete list, and descriptions of, the functions you can use in Planning and Essbase applications.) You can use functions to perform calculations like these:

Planning users only: You use a Smart List to select predefined options instead of typing an option in data form cells.