Loads data values from an external source into the currently selected database.
Syntax
IMPORT numeric dataFile fileType y/n ruleLoc rulobjName y/n [ErrorFile]
For an SQL data source, the syntax is as follows:
IMPORT 4 SQLUserName SQLUserPassword Ruleloc rulobjName y/n [ErrorFile]
Parameter | Description |
---|---|
numeric | Location of the dataFile file. Values: 1 - Local/client data file. 2 - Remote/server data file. 3 - File. 4 - SQL source. |
dataFile | Name of data source file. |
fileType | File type of dataFile. Values: 1 - Excel file 2 - Lotus 2 file (No longer supported) 3 - Lotus 3 file (No longer supported) 4 - Text file (No longer supported) 5 - Lotus 4 file (No longer supported) |
y/n | Whether to use rules when importing dataFile. |
ruleLoc | Location of the rulobjName file. Values: 1 - Local/client rule object file 2 - Remote/server rule object file 3 - File. Use option 3 if the file is not an Essbase object, or if you want to specify the full path name. Otherwise, Essbase looks in the <APPNAME>/<DBNAME> directory. |
rulobjName | Name of the rules file. |
y/n | Whether to abort on error. |
SQLUserName | User name that connects to the SQL database. |
SQLUserPassword | User password for the SQL database.. |
ErrorFile | The name of the error file. This is required only if you choose not to abort on error. |
Notes
Use the LOADDATA or UPDATEFILE commands to load data without a rules file.
Use the BUILDDIM command to build one or more dimensions in an outline.
Example
IMPORT 2 "ACTUALS" 4 "Y" 2 "ACTUALS" "Y";
The following UNIX example imports from an SQL data source, and specifies an error file.
import 4 "tbc" "password" 2 "sales" "N" /app1/imperror;
The following Windows example does the same as the above.
import 4 "tbc" "password" 2 "sales" "N" "c:\valscrt.ERR";
See Also