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 |