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:
Start the data load using the text file you have just created, for example, westout.
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.