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.
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:
Select the source database. For example, select West Westmkts.
See “Navigating and Selecting Objects” in the Oracle Essbase Administration Services Online Help.
See “Creating Scripts” in the Oracle Essbase Administration Services Online Help.
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
See “Executing Report Scripts” in the Oracle Essbase Administration Services Online Help.
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.