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 \\.
name (see MaxL Syntax Notes)
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.