Copy the outline file (.otl) of the source database to the new database that you have created. In this example, you copy the basic.otl outline file from the Sample.Basic database and rename it wesmkts.otl on Essbase Server 2.
How you copy the outline file depends on whether you can connect to the source Essbase database from the Essbase Server 2 computer.
If you can connect, use any of the following methods to copy the outline:
If you can not connect, use the operating system to copy the outline file.
Use the operating system to copy the source outline file; for example, copy basic.otl to westmkts.otl.
Give the copied outline exactly the same name as the new database.
Save the outline file in the ARBORPATH/app/appname/dbname directory on the Essbase Server 2 computer, where ARBORPATH is the directory in which you installed Essbase, and appname and dbname are the new application and database that you have created.
For example, copy basic.otl to a disk, renaming it to westmkts.otl. Then copy westmkts.otl from the disk to the following directory on Essbase Server 2:
Oracle/Middleware/EPMSystem11R1/products/Essbase/EssbaseServer/app/west/westmkts/westmkts.otl
It is safe to overwrite the existing, empty westmkts.otl file.
Stop and restart the new database.
See “Starting Databases” and “Stopping Databases” in the Oracle Essbase Administration Services Online Help.
You now have a copy of the database outline on Essbase Server 2.