This section lists the internal HS custom functions available for Financial Management for management reporting functions and planning functions. The functions include a description, type of function, syntax, example, and sample script.
Table 88. 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 89. 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 |