Creating a Script Custom Template

When you create a custom template using script, you can:

  • Deploy the script template to Oracle Hyperion Planning
  • Launch the template in Planning, where the steps will display allowing you to enter data at runtime
  • Use run-time functions and design-time prompts
To create a custom template using a script:
  1. In System View, right-click Templates, and then select New.
  2. In New Custom Defined Template, enter the requested information, and then click OK.
  3. When the template is opened, click the drop-down next to Designer, and then select Edit Script.
    This converts the template from graphical to script.
  4. In Properties, enter properties for the template.
  5. In the Template Designer, drag existing objects to the template’s script, or type in the script.

    To add an object, drag an object from Existing Objects and drop in into the script.

    If you drag a template into a script template, the template is always placed on the first line of script. To place the template somewhere else in the script, cut the entire line from the first line of the script, and then paste it in the desired location.

  6. Use the Design Time Prompt tab to enter design-time prompts that prompt you to enter information when you launch the template in Planning. See Creating Design-Time Prompts for Custom Templates
  7. Click Save button to save the template.
  8. Deploy the template to Planning.
  9. Open Planning, and the launch the template.