IMP-FILE

A name or absolute path to a server-side rules file or data file, used for import data and import dimension statements.

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

If you are using server data_file or server rules_file, you can get the file from any application (not just the current application) by starting the IMP-FILE string using the following pattern:

FILE_SEP AppName FILE_SEP DbName FILE_SEP rest_of_file_name

where FILE_SEP must be either / or \\.

Type

name (see MaxL Syntax Notes)

Examples

Consider the MaxL statement

import database demo.basic data
from server rules_file 'IMP-FILE'
on error abort;

If IMP-FILE is 'calcdat.txt', the file will be looked for in \Demo\Basic\calcdat.txt.

If IMP-FILE is '/Sample/Basic/calcdat.txt' (or '\\Sample\\Basic\\calcdat.txt'), the file will be looked for in \Sample\Basic\calcdat.txt.

If the FILE_SEP string FILE_SEP string FILE_SEP pattern does not start the string, the entire string is used as the file name, but the current application directory is assumed. For example, if the initial file separator is omitted and IMP-FILE is incorrectly specified as 'Sample/Basic/calcdat.txt', the file will be looked for in /Demo/Basic/Sample/Basic/calcdat.txt.

import database demo.basic data
from server file '/Sample/Basic/Calcdat.txt'
on error abort; 

Essbase looks for calcdat.txt inside the Sample.Basic directory, and loads the data to Demo.Basic.

Referenced By

import data

import dimensions