Exporting data
You can export the data, which you have imported to an OLAP database using Connector into a text file, for example, to re-import edited SunSystems data to a SunSystems database.
Note:
- For the export, information from the reference database and the repository are required. Therefore, only data can be exported which originate from OLAP databases and cubes, which you imported using Connector.
- To export the data of a data connection for cubes, you must enable the Allow Export option for the data connection. When you have enabled this option for a data connection, you must re-create the database.
You use the Export dialog, to export cube data to a text file. There are two ways to open the Export dialog:
- Right-click the cube and select .
- Right-click a data connection for cubes and select .
In the Export dialog, there are these options:
| Option | Description |
|---|---|
| Data connections for cubes | From the drop-down list, select the data connection for cubes, whose data you export. You cannot select the data connection, if you have opened the dialog by the shortcut menu of a data connection in the tree. |
| Business entity | From the drop-down list, select the business entity, whose data you export. |
| Periods | In the list, select the periods, whose data you export (multiple selection with Ctrl). |
| Scenario | From the drop-down list, select the scenario, whose data you export. |
| Bridge | From the drop-down list, select the bridge, whose data you export. |
| Journal type | If you select the file format SunSystems 4, you select the journal type of the transactions that you export here. If the journal types cannot be retrieved (error message), you can specify a journal type you know. |
| File format | Select the file format of the export file, for example, SunSystems 4 or SunSystems 5. |
| Filename | Specify the name and the path of the export file. |
| Transaction reference | Specify a text to be used as transaction reference for the export. |
| Description | Specify a text to be used as description for the export. |
Click to start the export.