The following custom functions are available for Oracle Hyperion Financial Management, Fusion Edition. This library of functions contains management reporting functions as well as planning functions.
The scope of this library is limited to the available internal HS functions that are implemented for Oracle Hyperion Financial Management, Fusion Edition.
Included are two sample VB Script rules files for these functions: one for management reporting functions and one for planning functions. You can copy and paste the relevant functions from the sample rules files to your own rules files.
Each custom function includes a short description, the type of function, the return value, the syntax, a detailed description, an example, and a sample script.
If you need to modify the custom function, you should copy the custom function provided and rename the function before making the changes.
Table 1. Management Reporting Functions
Hyperion Enterprise Equivalent
Calculates the financial average
Average (POV, Periods)
Accumulates amounts from prior periods
Cumulative (POV, View, NumPeriod)
CUM CTD YTD
Calculates the difference between current and opening