IMP-FILE

The IMP-FILE terminal in the MaxL language for Essbase represents a name or absolute path to a rule file or data file used for Import statements.

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 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 / 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' or '/Demo/Basic/calcdat.txt', the file will be looked for in the Demo.Basic cube directory.

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

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

Referenced By

import data

import dimensions