Export Excel
Exports an Essbase cube to an Excel application workbook. Application workbooks comprise a series of worksheets, which can appear in any order, and define a cube. The application workbook can later be imported to create a new cube.
Exporting a cube to Excel requires at least Database Manager permission.
To export to Excel:
- On the Applications page, click Jobs.
- From the New Job menu, select Export Excel.
- For Application, choose an application.
- For Database, choose a cube.
- Select a build method.
- Choose whether to export data. This option adds a data worksheet to the application workbook.
- Choose whether to export scripts. This option adds Calc and MDX sheets to the application workbook if calculation scripts and MDX scripts exist in the cube.
- Choose whether to export member IDs. This option adds Member IDs to the application workbook.
- Click Submit.