You use the Export Database dialog box to export data.
In the Export to file box, you identify the file or files and perhaps the location to which to export the data. As you enter your information, keep the following in mind:
Do not enclose a file name in double quotation marks.
To export data in parallel, specify a comma-separated list of files. The number of threads used depends on the number of file names.
By default, export files use .txt extensions. If you append a non-default extension, enclose it in single quotation marks.
By default, export files are stored in the application directory (ARBORPATH\app). To store a file in a non-default location, specify a full path to the location.
If you are exporting data, in the Export options group, you select one of the following options:
All data—All data, including consolidation and calculation results, is exported for block storage databases.
Level 0 data blocks—Only data from blocks that contain level 0 sparse member combinations is exported.
Input level data blocks—Only data from blocks that contain data from a previous data load or spreadsheet Lock & Send is exported, for block storage databases. Thus, consolidation and calculation results are not exported.
If you are exporting data from a block storage database, you can select the Export in column format option. When deciding whether to select the option, consider the following:
Because, in columnar format, each row includes a member name from each dimension and names can repeat from row to row, data loads into relational databases are facilitated.
A columnar structure enables data to be used by applications other than Essbase.
Because files in non-columnar format are smaller than files in columnar format, loading non-columnar files is faster.
You can select the Execute in the background option. During a background process, you can exit the console but you cannot shut down Essbase Administration Server. You can check the status of the export process in the Background Process Status window.
Note: | By default, Administration Services exports the database to the file system of the selected Essbase Administration Server, not to your local file system. |
export data (MaxL) in the Oracle Essbase Technical Reference
export (ESSCMD) in the Oracle Essbase Technical Reference