13 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 13-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 13-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 |