1. Administrator's Guide
  2. Using FDMEE
  3. Administration Tasks
  4. Registering Target Applications
  5. Defining Application Options for Essbase and Planning
  6. Using Calculation Scripts
  7. Adding Calculation Script Parameters

Adding Calculation Script Parameters

You parameterize calculation scripts by identifying and defining the list of values in the scripts. Parameter values can be predefined for a list of values, for example, the POV Period, POV Location, POV Category, Check Group Entity, and all data load entities.

You can also specify custom parameters, in which case, you can enter any Oracle Essbase filter syntax.

Additionally, you can reference values stored in the Integration Option 1-4 fields in the Location table to drive calculation logic. Location Option 1, Location Option 2, Location Option 3, and Location Option 4 values can be referenced. In this case, the exact string that is passed as a parameter must be stored in the Integration Option field of the Location table.

Similarly, you can reference four option fields in the Data Rule for parameters. These fields are Data Rule Option 1, Data Rule Option 2, Data Rule Option 3, and Data Rule Option 4. The column added to the Data Rule is called RULE_OPTION1, RULE_OPTION2, RULE_OPTION3 and RULE_OPTION4.

To add calculation script parameters:

  1. From the Calculation Script tab, add or select a calculation script.

  2. Click Image shows Edit icon to add the parameters for the calculation script.

  3. For Planning applications only: select the Plan Type for Accounting and Entity dimensions.


    Image shows Calculation Script Parameters screen

  4. In Script Parameters, select the parameter that has been defined for the script.

    You can click the Browse icon, select the parameter, and click OK.


    Image shows Calculation Script Parameter Names screen.

  5. In Script Value, select the value to which to apply the calculation script and click OK.

To add a custom script parameter:

  1. From the Calculation Script tab, add or select a calculation script.

  2. Click Image shows Edit icon to add the parameters for the calculation script.

  3. In Script Parameters, select the parameter that has been defined for the script.

    You can click the Browse icon, select the parameter, and click OK.

  4. In Script Value, select Custom and click OI.

  5. In Custom, enter the filter syntax for the custom value.

    For example, enter: 0001.