Introduction

In this chapter, we will review several different methods of moving data from one Essbase cube to another or from Essbase to a relational environment. The report script is the most versatile of tools as it has a full set of commands for reporting. The downside of report script is that it does not use the calculator cache to extract data and as a result it is not as fast as the DATAEXPORT function for example. The DATAEXPORT calculation function gives developers the ability to extract large amounts of data quickly into both flat file and relational targets. The disadvantage of DATAEXPORT is that it does not have the reporting depth of report script. A less flexible, yet powerful data export function is the export in column format method in Essbase Administration Services (EAS). The functionality will extract the entire content of your database in a tabular format delimited by spaces. This export method gives you the ability to export and then load large amounts of data via a...