1. Administrator's Guide
  2. Working with Detailed Profitability
  3. Calculating Detailed Profitability Models
  4. Pre- and Post-Calculation Custom Scripts

Pre- and Post-Calculation Custom Scripts

You can create custom pre- and post-calculation scripts to perform tasks either before or after calculation of the application to manipulate the model or stage data.

The custom scripts are run, as follows:

  • Pre-calculation SQL scripts run before the model calculations.

  • Post-calculation SQL scripts run after the model calculations.

The custom scripts are run to prepare for allocations before the model calculation or to enhance the results for reporting after mModel calculations.

Using SQL Developer or any third-party SQL tool, you create a simple series of SQL statements, separated by a delimiter. The custom scripts are stored in the SCRIPT column of the HPM_SQL_SCRIPT table in the database, within the Product Schema.

Select the custom script when you are creating your Calculation Parameters. Under Task Areas, select Calculate, then Manage Calculation, and then select the required pre- or post-calculation script. For detailed instructions, see the Oracle Hyperion Profitability and Cost Management User's Guide.

See these sections: