IMP-FILE

The IMP-FILE terminal represents a data or rule file name or path used for Import statements in MaxL. The file location can be specified as local or server, where local means from the same filesystem where the statement is issued, and server means the Essbase Server file catalog.

If the data or rule file is specified to be on the server, the following rules apply. If the data or rule file is specified to be local (or left unspecified, in which case it is also local), skip the following and refer to FILE-NAME.

If you are using server data_file or server rules_file, you can get the file from an Essbase Server catalog path, as shown in the example.

Type

name (see MaxL Syntax Notes)

Example

The following statement performs a data load using a data file stored in the shared folder of the Essbase file catalog. The rule file is in the cube directory for Sample Basic.

import database 'Sample'.'Basic' data from server data_file 'catalog/shared/Data_Basic' using server rules_file 'Data' on error write to "dataload.err";

For information about permitted import directories, refer to Specify Files in a Catalog Path.