Export a Cube to an Application Workbook

1. In Essbase, expand the application that contains the cube that you want to export.
2. From the Actions menu, to the right of the cube name, select Export to Excel.
3. On the Export to Excel dialog box:

   • Select Export Data if you want to export the data from the cube. How the data is exported depends on whether the cube is block storage or aggregate storage.

     • In block storage cubes, if the size of the data is 400 MB or less, it is exported to the application workbook, on the Data worksheet. If the data size exceeds 400 MB, data is exported to a flat file named Cubename.txt, which is included in a file named Cubename.zip on the Files page.

     • In aggregate storage cubes, regardless of the size, data is always exported to a flat file named Cubename.txt, which is included in a file named Cubename.zip on the Files page.

   • Select a build method, Generation or Parent-Child.
   • Select Export Calculation Script if you want to export each of the calculation scripts as a separate worksheet within the application workbook.
4. When prompted, save the exported application workbook to your local or network drive or download the exported application workbook and data .zip files from the Files page.
   File names do not include spaces because files that are imported to Essbase cannot contain spaces in the file name.

If you choose the options to include data, calculation scripts, or both in an export when they do not exist in the cube, the job completes without errors, but no data or scripts are exported.

The exported application workbook can be imported to Essbase. See:

• Create a Cube from an Application Workbook

• Create a Cube from a Local Application Workbook in Cube Designer