Library of Functions Overview
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
Custom Function | Description | Syntax | Function Type | Hyperion Enterprise Equivalent |
|---|
Average | Calculates the financial average | Average (POV, Periods) | Function | AVE A12 |
Cumulative | Accumulates amounts from prior periods | Cumulative (POV, View, NumPeriod) | Function | CUM CTD YTD |
Difference | Calculates the difference between current and opening | Difference (POV, View) | Function | DIF DFB |
DSO | Calculates the days sales are outstanding | DSO (DSO, Debtor, Sales, DIP) | Procedure | Procedure |
Opening | Carries opening balances forward | Opening (POV, View) | Function | OPE BASE BASEFLOW |
Rate | Gets the relative exchange rate | Rate (ExchangeRate, Triangulation Currency) | Function | CrossRate |
Table 2. Planning Functions
Custom Function | Description | Parameters | Function Type |
|---|
Units_Rates | Units * rates (C=A*B) | Unit_Rates (Description, Units, Rates) | Procedure |
Custom_Alloc | Allocates in the custom dimension | Custom_Alloc (Destination, Source, Factor, FactorN, FactorD, Elimination) | Procedure |
Increase_Decrease | Increases or decreases the account by a percentage | Increase_Decrease (Destination, Source, Factor, Scale, Inverse) | Procedure |
Pro_Rata_Ratio | The ratio between 2 accounts | Pro_Rata_Ratio (Destination, SourceN, SourceD) | Procedure |
Spread | Spreads the total amount among all periods in the year | Spread (Destination, Source, Factor, FactorN, FactorD, Temp, Per) | Procedure |