Exports data from an application cube (Oracle Essbase cube) to an archive. You can export just the level 0 data (ASO and BSO cubes) or all data in the cube (BSO cubes).

Use the exported archive to analyze Essbase data for patterns, for example to help improve performance.

Running a data export places the cube into read-only mode and prevents any write activity while the export operation is in progress.

Applies to

Planning, Planning Modules, FreeForm, Financial Consolidation and Close, Tax Reporting, Enterprise Profitability and Cost Management, Strategic Workforce Planning, and Sales Planning.

Required Roles

Service Administrator


epmautomate exportEssbaseData CUBE_NAME FILE_NAME [level=0|All] where:

  • CUBE_NAME identifies the cube from which data is to be exported.
  • FILE_NAME is the name of a ZIP file that will contain the exported data. You can download this archive by running the downloadFile command.
  • level, optionally, identifies the level of data to be exported. Default is 0.
    • ASO cubes: Specify 0 to export level 0 data. You cannot use the All option.
    • BSO cubes: Specify 0 to export level 0 data or All to export all data.


  • Export all data from a BSO cube:

    epmautomate exportEssbaseData Report1 Report1_all_data.zip level=All

  • Export level 0 data from a cube:

    epmautomate exportEssbaseData Plan1 Plan1_lvl0_data.zip