O'Reilly logo

Oracle Essbase 11 Development Cookbook by Jose R. Ruiz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Exporting data using column format

In this recipe, we will use a column format export to extract all the data from Sample.Basic at the lowest level. We will also create a separate database for the purpose of loading this columnar export via a load rule. The column format is the least flexible method of exporting data from a database as data is exported in the format of the Essbase outline. Moreover, we cannot specify a slice of the database for export with column format export. On the other, it is one of the fastest ways of extracting all data from an Essbase database.

Getting ready

To get started, click on the Start menu and navigate to Programs | Oracle EPM System | Essbase | Essbase Administration Services | Start Administration Services Console ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required