Export Data

The function fExpVal makes it possible to export data from the IBM® Controller Link for Microsoft Excel into the IBM Controller database. The values that can be exported are always reported values (REPO).

Before you create your Microsoft Excel sheet for exporting data, try to define an efficient design. For each and every parameter, enter the reference to the corresponding cell in the Excel sheet. If you use absolute and relative references in this function you can easily copy and paste the function to cover all records in your Excel sheet.

Note:

The file names of Microsoft Excel reports must be 80 characters or less. If a file name exceeds 80 characters, the following message appears:

There were no fExpVal functions found.

Procedure

  1. Log on to the IBM Controller Link for Microsoft Excel.
  2. Prepare all your reported values (REPO) in the excel sheet. It is not possible to prepare an export for company journals, group journals or automatic journals. An example: If you want to export the budget values for the next year, insert fGetVal functions to get the actual values from the last year. In the next cell you can e.g. multiply the actual value by 1,1 (10% increase) to get the value you want as budget value.
  3. Go to an empty cell where you want to paste your cc.fExpVal function.
  4. On the Insert menu, click the Formulas tab/Function Library group/Insert Function (Excel 2007), or click the Paste Functions button. The dialog box Insert Functions opens. The all Function categories are displayed.
  5. In the category list box, select the Controller category. All available functions are displayed in this list box.
  6. Select the fExpVal function and click OK. A dialog box opens.
  7. Enter the function parameters and click OK. The parameters can be cell references or values.
  8. To execute the export, log on to the IBM Controller Link for Microsoft Excel and click the menu Export Data under the Controller menu.
    Note: Assigning the formula fExpVal to cells, which contain duplicate information is not permitted when you use the IBM Controller Link for Microsoft Excel. An example is where multiple duplicate cells relate to the same period, actuality company, currency, extended dimensions 1-4, and other dimensions are assigned fExpVal formulae. This scenario is not permitted. The expected behavior would be to aggregate these cells to one cell and assign a single fExpVal formula on the aggregated cell.