Load the Output File into the New Database

Load the output file into the new database on Essbase Server 2.

  To load a file into a database, see “Performing a Data Load or Dimension Build” in the Oracle Essbase Administration Services Online Help.

The following example illustrates how to load data into the Westmkts database:

  1. Select the new database. For example, select Westmkts.

  2. Start the data load using the text file you have just created, for example, westout.

    Note:

    If westout is not displayed, check that you gave it a .txt extension and placed it in the ARBORPATH/app/West/Westmkts directory. See Create an Output File Containing the Required Data Subset.

See Performing and Debugging Data Loads or Dimension Builds.

You can now view the data on the Essbase Server 2 computer. You might need to recalculate the database subset. Because you are viewing a subset of the database, a percentage of data values will be #MISSING.

If required, you can copy report scripts and other artifact files to the Essbase Server 2 computer to use with the database subset that you have created.