Databases Reference
In-Depth Information
CALCDEFAULT;
/* Executes the default calculation on the selected
database */
IFERROR "ERROR";
/* On an error the script will branch to the
"ERROR" line */
UNLOADDB appName dbName;
/* Unloads the specified database
from memory */
IFERROR "ERROR";
/* On an error the script will branch to the
"ERROR" line */
UNLOADAPP appName;
/* Unloads the specified application from memory */
IFERROR "ERROR";
/* On an error the script will branch to the
"ERROR" line */
Now, let's add these lines to the rest of the script and see what a complete EssCmd
script looks like.
The finished script
Here is what your EssCmd script should look like with all of the commands added.
It is ready to execute and in the next section, we will discuss the ways to execute an
Essbase Command script.
OUTPUT 1 "c:\EssCmd.log";
/* The 1 specifies turning job log output
on and then you code the log's
location */
IFERROR "ERROR";
/* On an error the script will branch to the
"ERROR" line */
LOGIN hostNode userName password;
/* Connect to Essbase server */
IFERROR "ERROR";
/* On an error the script will branch to the
"ERROR" line */
SELECT appName dbName;
/* Connect to specific application/database */
IFERROR "ERROR";
/* On an error the script will branch to the
"ERROR" line */
LOADAPP appName;
/* Loads the specified application into memory */
IFERROR "ERROR";
/* On an error the script will branch to the
"ERROR" line */
LOADDB appName dbName;
/* Loads the specified database into memory */
IFERROR "ERROR";
/* On an error the script will branch to the
"ERROR" line */
