To restore linked reporting objects (LROs) after you back up or clear a database, you import the LROs that you previously exported from the database. To import LROs, you need Write permissions for the database.
When you import LROs, you specify the directory that contains the LRO information that you want to import. This directory must exist from a previous export. The export directory contains an .exp file that contains LRO catalog information and individual attached LRO files.
To import LROs to a database:
From Enterprise View or a custom view, select a database.
Under the database node, right-click Linked Reporting Objects and select Import linked reporting objects.
Essbase opens the Import LROs dialog box.
To import LROs from a directory on a local computer or network:
In the text box, specify the full path to the directory from which you want to import, or browse to the directory.
To import LROs from a directory on Essbase Server:
Select Essbase Server directory.
Note: | This option is available only if Essbase Server detects an export directory on the server. |
In Essbase Server directory, select the directory on the server from which you want to import LRO information.
To delete the export directory after the import is completed, select Delete LRO directory on server after import.
Click OK.
export lro (MaxL) in the Oracle Essbase Technical Reference
import lro (MaxL) in the Oracle Essbase Technical Reference