Hyperion Essbase Knowledgebase

Essbase tips: Extracting data from Essbase

User Rating:  / 1
PoorBest 
Method Performance Output Limitations - Benefits Launching Method
Database Export fastest way to export level 0 or all levels of a database

Text file column delimited (the columns are made up of a dense dimension, usually your months)

 

You get the entire database at level 0 (or all levels). You can't specify just a region or product grouping. You will need to filter out the pieces of data if you don't want it all. In order to get to this file, you'll need to have some kind of access to the server to get the file (a little difficult when running unix)

this can be kicked off interactively via EAS (using mouse), esscmd, or Maxl.
Report Script slowest

the output can be a window in EAS, a text file on a client pc, a text file on the server, excel

This method is very, very slow. The output can be highly customized. If you only need a small set of data this might be your solution. If you don't have access to the server (on unix or cannot map to your essbase server) you can use this to get the file to your pc. these can be launched in excel, eas (using mouse), esscmd, and maxl. This is the slowest method of exporting data.
jexport (custom defined function) pre system 9 fast text file, relational database

This has been replaced by the export command in system 9. This custom defined function is a little tricky in getting installed and setup. You have to spend some time testing as it's easy to get duplicate data when using this command. This is an unsupported export method from Oracle as it's custom java that is not delivered with the software. This can be downloaded from Oracle utilities for Essbase.

these can be launched in excel, eas (using mouse), esscmd, and maxl. This is the slowest method of exporting data.
dataexport fastest text file on server, relational database via odbc Use this when you need a subset of the database that does not consist of level 0 members or where a level 0 would be overkill. You can choose any level of the database.This command replaces the custom defined jexport function in system 9 and 11. There have been some bugs reported when using this to output to a relational data store (esp on unix) so run this through some extra testing. these can be launched in excel, eas (using mouse), esscmd, and maxl. This is the slowest method of exporting data.
replicated partition not too slow Essbase Database Partitioning when designed properly can be a viable solution.  You have to make sure your partition mappings are in sync.  You don't have to keep track of data files and file paths. In order to get fast performance try to focus on level 0 where possible. A drawback is that partitions get corrupted easily therefore you should create the partition via automation like esscmd or maxl. Also you cannot create a partition while the database is calcing.  A partition refresh can be kicked off interactively in EAS or via an automation like esscmd or maxl.

Additional information