To prepare for backing up or clearing data, you can preserve linked reporting objects (LROs) by exporting them. LROs are not preserved when you clear data from a database, and they are not restored with databases that are restored from backups. To export LROs, you need Read permission for the database.
When you export LROs, you specify a directory to which to export LRO information. The LRO export directory contains the following:
A text file with an .exp extension that contains LRO file locations, cell note text and URL text, and database index locations to use for importing to the correct data blocks
LRO binary files (if the database from which LROs were exported contained file-type LROs)
Exported LROs can then be imported to another database.
To export LROs:
From Enterprise View or a custom view, select a database.
Under the database node, right-click Linked Reporting Objects and select Export linked reporting objects.
Essbase opens the Export LROs dialog box.
To export LROs to a directory on Essbase Server:
In LRO export directory, specify the directory on the server to which you want to export LRO information.
To export LROs to a directory on a client computer or network:
Click OK.
export lro (MaxL) in the Oracle Essbase Technical Reference
import lro (MaxL) in the Oracle Essbase Technical Reference