Updating a SQL Script, Importing, and Calculating a Data Sample File

Suppose you need a script file that:

Logs in to Essbase Server.
Selects an application and database.
Prevents other users from logging on and making changes to the database.
Updates the outline from an SQL data source.
Imports data from SQL.
Calculates the database.
Exits ESSCMD.

The following script file does the job:

LOGIN "Poplar" "TomT" "Password";
SELECT "Sample" "Basic";
DISABLELOGIN;
BUILDDIM 2 "PRODRUL" 4 "PRODTBL" 4 
"
PROD.ERR
"
;
IMPORT 4 "TOMT" "PASSWORD" 2 "ACTUAL" "N";
CALCDEFAULT;
EXIT;

On Windows, this script file, sample2.scr, is available in \ARBORPATH\APP\SAMPLE\BASIC. On UNIX, it is in the /$ARBORPATH/app/Sample/Basic directory.