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 Planning application.

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.

6. Click OK.