You import LROs from the specified output directory created by export lro. The directory contains an ASCII .exp file containing LRO-catalog information, and LRO binary files (if the database from which LROs were exported contained file-type LROs).

Syntax

• DBS-NAME

• IMPORT-DIR

Keywords

You can import exported LRO information to a cube using MaxL import lro in the following ways. The minimum application permission required for this action is Database Update.

import database DBS-NAME lro from local directory IMPORT-DIR

Import Linked Reporting Objects (LROs) from the specified export directory on the local machine.

import database DBS-NAME lro from server directory IMPORT-DIR

Import Linked Reporting Objects (LROs) from the specified export directory on Essbase Server.

Notes

• This statement requires the cube to be started.

• The specified LRO import directory must come from the results of the export lro operation. The exported LRO-catalog file contains a record of the LRO file locations, cell notes, or URL text, and database index locations to use for re-importing to the correct data blocks.

• In the paths in the second two examples, double quotation marks are used to allow variable expansion in the string IMPORT-DIR, and single quotation marks are required because there are special characters (see MaxL Syntax Notes) in the path name.

Windows Example

Referencing an absolute path to an export directory:

import database sample.basic lro from local directory 'C:\\Oracle\\EssbaseMaxL\\myexports';

Linux Example

Referencing an absolute path to an export directory:

import database sample.basic lro from local directory '/scratch/exports/lros';

Generic Example

The following example works on Windows or Linux. It references a server directory, <Application Directory>/app/Sample-Basic-exportedLROs:

import database sample.basic lro from server directory 'Sample-Basic-exportedLROs';

If you do not know where Application Directory is in your environment, refer to Environment Locations in the Essbase Platform.