Exporting Essbase Data

DATAEXPORT command in Essbase provides a very useful way to extract data from the Essbase cube.

This exported file can be easily used to import data in case of data corruption or can be kept as a DataBackup for future purpose.

Usual usage of DATAEXPORT is
DATAEXPORT "File" "delimiter" "fileName" "missingChar"
e.g. DATAEXPORT "File" "," "Lev0Budget.txt" "#Missing"

This will generate a Datafile, with a comma delemeted format, with missing data specifies with #Missing.

One important consideration while using the DATAEXPORT command, which might lead to losing the usability of the file (In case you are hoping to use the data export text file to import back into the database sometime), is that for Free Form Import (without a Rule File), Essbase requires the DATAEXPORT to be processed in a unique way, as below:

DATAEXPORT "File" " " "Lev0Budget.txt" "#Mi"

The file which you want to import in free form without using a Rule file, MUST specify the delimeter as SPACE and Missingchar as #Mi.


Posted on March 15, 2016, in Oracle Essbase. Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: