Process for Creating a Database Subset

You can move data between Essbase databases or to other programs by extracting an output file of the data that you want to move. To meet the import format specifications of most other programs, create a text file using a report script or a calculation script.

This section describes the process for copying a database subset from one Essbase Server (Essbase Server 1) to another (Essbase Server 2).

  1. On Essbase Server 2, create an application and database to contain the database subset.

    See Create an Application and Database.

  2. Copy the outline file (for example, source_dbname.otl) from the source database on Essbase Server 1 to the new database on Essbase Server 2.

    You may need to rename the outline file to match the name of the database Essbase Server 2 (for example, target_dbname.otl), overwriting the existing target database outline file.

    See Copy the Outline File from the Source Database.

  3. Create an output file (for example, a plain text file) containing the required data subset.

    See Create an Output File Containing the Required Data Subset.

  4. Load the output file into the new database that you have created.

    See Load the Output File into the New Database.

If required, repeat steps 3 and 4 to create an output file from the database on Essbase Server 2 and load the data back into the main Essbase database on a different computer.

The example in the following sections is based on the Sample.Basic database. The data subset in the example is the Actual, Measures data for the West market. The example copies the data subset to Essbase Server 2 and the West Westmkts database.