Loads data values from an external source into the currently selected database.
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]
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. 3 - Lotus 3 file. 4 - Text file. 5 - Lotus 4 file. |
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 Analytic Services object, or if you want to specify the full path name. Otherwise, Analytic Services 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. |
IMPORT 2 "ACTUALS" 4 "Y" 2 "ACTUALS" "Y";
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |