Import LRO

The MaxL import lro statement helps you import Linked Reporting Objects (LROs) into an Essbase cube.

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).

Minimum permission required: Write.

Syntax

Description of the illustration imp_lros.gif

• DBS-NAME

• IMPORT-DIR

You can import exported LRO information to a cube using import lro.

Keywords

import database <dbs-name> lro...

Import Linked Reporting Objects (LROs) from the specified export directory on the local machine or on a remote server where the Essbase Server resides.

Notes

• This statement requires the cube to be started.

• The specified 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.

Example

Windows Example

Referencing an absolute path to an export directory:

import database sample.basic lro
from server directory 'C:\\exports\\lros';

Linux Example

Referencing an absolute path to an export directory:

import database sample.basic lro from server 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 directory 'Sample-Basic-exportedLROs';

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