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