Inserting Functions into Components

The function types you can select from differ depending on the application type and component type with which you are working.

You can insert functions into formula, script, condition, and member range components, if you are working with a Oracle Hyperion Financial Management, Oracle Hyperion Planning, or Oracle Essbase block storage application.

You can insert functions only into Point of View components if you are working with an Essbase aggregate storage application, including those Essbase aggregate storage applications used in Oracle General Ledger and Planning. In Essbase aggregate storage applications, there is only one function type to select from: the member set function type. (See the second procedure in this topic.)

To insert a function into formula, script, condition, or member range component:

1. Do one of these tasks:

   • Open the business rule that contains the component into which you want to insert a function. Then select the component for which you want to insert a function in the business rule's flow chart.

   • Open the template that contains the component into which you want to insert a function. Then select the component for which you want to insert a function in the template's flow chart.

   • Open the formula component into which you want to insert a function.

   • Open the script component into which you want to insert a function.

2. Do one of these tasks:

   • To insert a function into a formula component, on the Formula tab, click in the Formula row, select the Actions icon, and select Functions.

   • To insert a function into a script component, on the Script tab, click the Insert a function and its parameters icon.

   • To insert a function into a member range component, on the Member Range tab, click in the Value column for a dimension, select the Actions icon, and select Functions.

   • To insert a function into a condition component, on the Condition tab, click the Condition Builder icon. In the Condition Builder, from Formula, Function, or Value, select the Actions icon, and select Functions.

3. In the Function Selector, do one of these tasks:

   Note:

   Depending on the context in which you open the Function Selector, the available function types may be more limited than the function types described in Working with Functions.

   • If you can select function types from Category, select one, or select All Functions to display functions for all function types. The functions for the category, or all functions, are displayed in a list below the Category selection.

   • If you cannot select among function types in Category, proceed to 4.

4. Select a function from the list of functions.

5. Enter parameters for the function. (See the Oracle Essbase Technical Reference for a description of the functions and parameters you can use for Planning and Essbase components, including those used in Oracle Fusion General Ledger applications. See the Oracle Hyperion Financial Management Administrator’s Guide for a description of the functions and parameters you can use in Financial Management components.)

6. Click OK.

To insert a function into a Point of View component:

1. From the System View, expand the Essbase application type, the application, the database, and Rules.

2. Open the business rule that contains the Point of View component into which you want to insert a function. Then select the Point of View component for which you want to insert a function in the business rule's flow chart.

3. To insert a function into a Point of View component, on the Point of View tab, click in the Value column for a dimension, select the Actions icon, and select Functions.

4. In the Function Selector, select a function from the list of functions:

   • @Attribute

   • @Level0Descendants

   • @Siblings

   • @UDA

   Note:

   Only Member Set functions are available when you are working in Essbase aggregate storage applications, including those used in Oracle General Ledger.

5. Enter parameters for the function. (See the Oracle Essbase Technical Reference for a description of the functions and parameters.)

6. Click OK.