IBM Controller Functions in Microsoft Excel
You can use functions and parameters to load data from the
Controller database.
You can, for example, load company names or other text information, values from the investments register or monthly values. A complete list of Controller functions is available in IBM Controller Functions.
Example
An example of an fGetVal Formula that fetches data from the Controller database can look like this:
=cc.fGetVal("0106";"+0";"YTD";"AC";"1200";"LE";"";"LC";
"30100";"";"FR1";"";"";"";"REPO";"T";"";"F";"";"";"";0)
Where 0106 = Period
0+ = Relation
YTD = Interval
AC = Actuality
1200 = Company
LE = Consolidation Type
LC = Local Currency
30100 = Account
FR1 = Dimension
REPO = Closing Version
T/F = True/False (used for closing version/contribution version)
Prerequisites
- All functions begin with "=cc.", for example, "=cc.fAcc()".
- Many of the functions use parameters as input. The parameters can be expressed as a code, a cell reference or a system column/row.
- Depending on your operative system settings (see the Control Panel), the character used for separating parameters can differ.