1. Using Oracle Essbase
  2. Run and Manage Jobs Using the Web Interface
  3. Execute Jobs
  4. Export Data

Export Data

Export data to a text file. You can choose what Essbase 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.


Image of the Export Data dialog box, in Jobs.

To export data:
  1. On the Applications 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 Data Level, 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 Image of the download icon..

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