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 imp_lros.gif follows Description of imp_lros.gif follows](img/imp_lros.gif)
Description of the illustration imp_lros.gif
You can import exported LRO information to a cube using import lro.
Keywords
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.