To export data from a database to move data between Essbase databases or to a format that can be read by programs other than Essbase, use a tool:
Tool | Topic | Location |
---|---|---|
Spreadsheet Add-in Query Designer | Applying Queries | Oracle Essbase Spreadsheet Add-in User's Guide |
Smart View | “Working with Query Designer” | Oracle Hyperion Smart View for Office User's Guide |
MaxL | export data | Oracle Essbase Technical Reference |
Calculation scripts | Oracle Essbase Database Administrator's Guide | |
Report scripts | Oracle Essbase Database Administrator's Guide |
When you use MaxL, calculation scripts, or Administration Services Console to export text data, and the end fields of the last record have no values, those fields will not contain the missing value marker (such as #MI). To improve overall processing time, the fields are left blank in the last output record. |
Export files from databases in Unicode-mode applications are in UTF-8 encoding. If Essbase finds insufficient disk space for the export file, no data is exported.
If you plan to import Essbase data into a program that requires special delimiters, use the Report Writer MASK command or the delimiter parameter of the DATAEXPORT calculation command to specify the delimiter.
For more information about exporting data for backup purposes, see the Oracle Hyperion Enterprise Performance Management System Backup and Recovery Guide.
You can use report scripts or calculation scripts to export Essbase data in text format. Both tools enable you to create text files that meet the import format specifications of most other programs.