Export to Table Format

Export a cube into Excel, in tabular format. Essbase generates flattened output from the cube into Excel. Exporting a cube in tabular format can facilitate moving and sharing data between Essbase and a relational source.

Exporting to table format requires at least Database Update application permission.

This exported tabular data is organized into columns with headers that Essbase can use to deploy a new multidimensional cube. See Export a Cube to Tabular Data.

To export a cube in tabular format:

1. On the Applications page, click Jobs.
2. From the New Job menu, select Export to Table Format.
3. For Application, select an application.
4. Choose whether to export dynamic blocks.

   If you choose Export Dynamic Blocks, cells for dynamic members in the dense dimensions are exported.