Exporting Data

  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

MaxLexport dataOracle Essbase Technical Reference

Calculation scripts

Exporting Data Using the DATAEXPORT Command

Oracle Essbase Database Administrator's Guide

Report scripts

Exporting Text Data Using Report Scripts

Oracle Essbase Database Administrator's Guide

Note:

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.