The Export Data job in the Essbase web interface enables you to export data to a text file. You can choose which data level to export, whether to export in column format, and whether to compress the data to a ZIP file. Exporting data requires at least Database Manager permission.

To export data,

1. On the Home page, click Jobs.

2. From the New Job menu, select Export Data.

3. For Application, choose an application.

4. For Database, choose a cube.

5. For Export Build Method, select a data level.

   You can choose from All Data, Level 0 Data, or Input Data.

6. Select Column Format to export the data in column format.

7. Select Compress to export the data to a ZIP file.

8. Click Submit.

To download the exported data file,

1. On the applications page, click Jobs.

2. Select the Actions menu to the right of the export job.

3. Select Job Details.

4. To view the data file, you can click the Output Path link, or to download the file, select download .

   The exported data file is stored in the database folder in the catalog.