12 Custom Functions
This section lists the internal HS custom functions available for Oracle Hyperion Financial Management for management reporting functions and planning functions. The functions include a description, type of function, syntax, example, and sample script.
Table 12-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 12-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 |
Ratio between two 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 |