Export Data - the Investment Register Tab

You can use this tab to select the investment register data for acquisitions you want to export and to select the conditions you want to apply to the export function.

Note: Export will be performed for data with transaction dates corresponding to the period(s) selected. Data with transaction dates outside of the selected periods will not be exported.

Procedure

  1. On the Transfer menu, click Export Data. The Export Data window opens.
  2. If you want to save the export file to a directory on your hard drive or on the server, select the Directory option button. In the Directory text box, enter the path to the directory to which you want to save the export file, or click the Select Directory button to select the relevant directory.
  3. If you want to send the export file via e-mail to a specified user, select the E-mail option button. In the Directory text box, enter the e-mail address of the user you want to send the file to. You can also click the Show Valid Choices button and log in to your e-mail application and select the relevant user. The e-mail functionality is only available if you have activated it in General Configuration, General 3 tab and entered the SMTP server address to be used.
  4. Select the Compress Export file option to create only one export file, which contains all relevant data and file types. Compression means that the size of the file is reduced and it can therefore not be edited or read outside IBM® Cognos Controller, unlike an uncompressed file. Uncompressed file format is used, for example, when the data files are to be imported in other financial systems.
  5. On the Investment Register tab, enter the period for which you want to export investments.
  6. Enter the consolidation type and group code for which you want to export investments.
  7. Enter the number of levels you want to export investments for. Level 1 is default and will export the group's total investments. The group itself is defined as level 0.
  8. Enter a name of the export file or leave the suggested file name (period number and company/group code).
  9. Click the Run button. If you entered an e-mail address to send the export file to, the e-mail application log on window opens. Log on to send the export file via e-mail. If you entered a directory to save the export file to, the data is exported and a message box appears with export statistics.
  10. Click OK.