Databases Reference
In-Depth Information
You now have opened the
Essbase Command Mode Interface
. At the command
prompt, you can begin entering commands. We suppose the first thing you should
do is log in to an Essbase analytic server or else you will just sit there.
You enter your commands exactly as you would type them into an EssCmd script
file as illustrated previously in this chapter. Also, remember to always terminate
a command line with a semi-colon, just as is required in an EssCmd script file.
EssCmd processing in batch mode
Essbase command batch processing mode lets you automate your routine analytic
services maintenance and diagnostic tasks for the server, applications, and databases.
You can write a script or batch file and run it from the command line. Or you can call
a script from a batch job and run it fully automated.
Batch processing mode is convenient if you frequently use a particular series of
repeated commands or if your tasks require many commands and the ability to
test for processing errors.
A batch file is an operating system file that can call EssCmd scripts and can also
include operating system commands. You can use one batch file to run multiple
sessions of EssCmd. This can be a licensing consideration since multiple EssCmd
connections connected through the same EssCmd session count as only one license
port, thereby saving on potentially expensive system licensing.
You can run a batch file on the analytic server from the operating system command
prompt and the file is processed by the operating system. On Windows and Windows
NT systems, batch files have
.bat
file extensions. These files can also be scheduled to
run automatically from the Task Scheduler, thus fully automating your processes.
To run an Essbase EssCmd script from the DOS command line prompt, simply
enter the fully qualified path to the EssCmd script file as shown:
ESSCMD C:\Batch.SCR
The line above will execute the EssCmd script file named
Batch.SCR
.
To have a batch file execute an Essbase EssCmd script, you would place a line
like the following line in a
.bat
file and execute the batch file:
ESSCMD C:\Batch.SCR
Well there you have it! You may be wondering why such a relatively easy to use
set of powerful tools would be getting phased out but just wait until you read the
next section on Essbase MaxL scripts. The MaxL scripts are replacing the Essbase
command scripts and are a more powerful, easier to use, intuitive, and interactive
scripting tool for Essbase.
