About System Templates

System templates are predefined templates that perform calculations.

Calculations preformed by system templates include clearing data; copying data; calculating amounts, units and rates; distributing data; allocating values; aggregating data; entering script commands to optimize performance; and converting account values to reporting currencies.

You can include system templates in:

  • Graphical or script business rules

  • Graphical or script custom templates

As a component of a business rule or custom template, a system template contains a series of steps into which you enter parameters. These parameters, combined with the template logic, generate a calculation script within the business rule or template. This makes the templates easier to use, and reduces potential calculation script syntax errors.

In Oracle Hyperion Calculation Manager, all system templates are available as wizards. Working with system templates in a wizard makes the templates easier to use, and reduces potential calculation script syntax errors.

The prompts in system templates are filtered based on the choices made in the wizard. For example, the Aggregation system template displays a step for selecting dense dimensions to aggregate, but if there are no dense dimensions available for aggregation, then the steps for full and partial dense dimensions are not displayed.

Note:

You can use system templates in Oracle Hyperion Financial Management, Oracle Hyperion Planning block storage applications, and Oracle Essbase block storage applications. Essbase ASO applications do not support system templates.