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:
- On the Applications page, click Jobs.
- From the New Job menu, select Export to Table Format.
- For Application, select an application.
- Choose whether to export dynamic blocks.
If you choose Export Dynamic Blocks, cells for dynamic members in the dense dimensions are exported.
- Click Submit.