Create an Output File Containing the Required Data Subset

Create an output file that contains the required data subset. The output file can be a text file or a spreadsheet file. Use either of the following methods to create a data subset.

  To create an output file for a subset of a database, use a tool:

The following example uses Report Writer to create a subset of the Westmkts database. You can also use a report script to export a subset of data.

  To create a text file that contains the required data subset:

  1. Select the source database. For example, select West Westmkts.

    See “Navigating and Selecting Objects” in the Oracle Essbase Administration Services Online Help.

    • If you can connect to the Essbase Server 1 database from the Essbase Server 2 computer, you can select the source database from Essbase Server 2.

    • If you cannot connect, use a different computer from the Essbase Server 2 computer to select the source database.

  2. Create a report.

    See “Creating Scripts” in the Oracle Essbase Administration Services Online Help.

  3. Write a report script that selects the required data subset. For information about writing report scripts, see Understanding Report Script Basics.

    For example, the following report script selects the Actual, Measures data for the West market from Sample.Basic:

    {TABDELIMT}
    QUOTEMBRNAMES
    Actual
    <IDESC West
    <IDESC Measures
    • Use TABDELIMIT to place tab stops between data, instead of spaces, to ensure that no member names or data values are truncated.

    • Use QUOTEMBRNAMES to place quotation marks (" ") around member names that contain blank spaces. Essbase then recognizes the member names when it loads the data.

  4. Execute the report script.

    See “Executing Report Scripts” in the Oracle Essbase Administration Services Online Help.

  5. Save the report script with a .txt extension; for example, westout.txt.

    To load the data, the output file must be in the ARBORPATH/app/appname/dbname directory on Essbase Server 2, where appname and dbname are the new application and database directories that you have created.

    If you are using the Essbase Server 2 computer, you can save the output file directly into the ARBORPATH/app/appname/dbname directory; for example:

    Oracle/Middleware/EPMSystem11R1/products/Essbase/EssbaseServer/app/west/westmkts/westout.txt

    If you are not using the Essbase Server 2 computer, save the output file anywhere on the current computer. By default, Essbase saves the file on the Essbase client computer and not on the server. When you run the report, use the operating system to copy the file to the ARBORPATH/app/appname/dbname directory on Essbase Server 2. For example, use a disk to copy the file.

    If you are not using the Essbase Server 2 computer, download and copy the file from the Essbase client directory to the ARBORPATH/app/appname/dbname directory on Essbase Server 2. For example, copy the output file to:

    Oracle/Middleware/EPMSystem11R1/products/Essbase/EssbaseServer/app/west/westmkts/westout.txt

You are now ready to load the text file into the new database.