Sample Script: Building Dimensions and Importing and Calculating Data from a SQL Source
The sample2.scr file executes the following actions:
Logs on 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
Reenables logins
Exits ESSCMD
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;