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

Using the DATAEXPORT function to extract data into a relational source

In this recipe, we will use the DATAEXPORT function to extract data from Essbase directly into a relational table. In order to accomplish this task, you need a DSN and a table in the relational environment that is set up with the same column structure as your export. You will also need to set up your DATAEXPORT with the parameters needed for this task. This functionality is only available in the Block Storage (BSO) cube.

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. In the Log in menu, enter your Administration Server, Username, Password, ...

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