Insert IBM Controller Functions

In Microsoft Excel, select Functions on the Formulas tab/Function Library group/Insert Function (Excel 2007), the Paste Function window opens.

By using the Controller functions it is possible to retrieve data directly from the Controller database.

One of the most important functions is the fGetVal function, which retrieves for example monthly values or year-to-date values.

After you have entered a function in the Excel sheet you have to select the Controller/Reports/Refresh F9 menu to download the latest updated data.

For more information, see Update Data.

Procedure

  1. Place the cursor on the cell where you want to paste the information.
  2. On the insert menu, click Functions or click the Paste Function button. The dialog box Paste Function opens. On the left hand side all Function categories are displayed.
  3. Select the Controller category. All available functions are displayed in the list box to the right.
  4. Select the desired function in the list box to the right and click OK. A dialog box opens.
  5. Enter the function parameters. The parameters can be cell references or values. Use the scroll bar to view all parameter input boxes.
  6. Click OK. The information is displayed in the cell. See Controller functions for more information about all available functions and input parameters.