Databases Reference
In-Depth Information
Executing MaxL from Command Prompt
When you install the Essbase client, by default, the MaxL shell executable is provided
and is named
essmsh.exe
. This executable will be located in the
bin
folder of the
Oracle client home install folder, typically as shown:
<Hyperion_home>\AnalyticServices\bin
The extension for a MaxL file is
.mxl,
and the files are ASCII text files, which you
can write statements and edit in any common text editor like Windows Notepad.
To execute your script you go to the
bin
folder path and fire off the MaxL script
as shown below.
Open a blank Notepad text file and type in these MaxL statements:
spool on to 'C:\book\MaxlOutput.txt';
/* This sends all the Maxl
outputs to the File
mentioned */
login hypuser password on localhost;
/* Log in to the Essbase
Server */
create application 'EsscarN';
/* This Step creates the
Application called EsscarN */
create database 'EsscarN'.'EsscarN' as 'Esscar'.'Esscar';
/*
This creates the copy of the Database Esscar and new Database name
is EsscarN */
alter database 'EsscarN'.'EsscarN' reset data;
/*
This statement will clear all the Pre-existing data */
alter database 'EsscarN'.'EsscarN' set variable 'sCurrMonth' '200902';
/* Sets a variable called sCurrMonth */
import database 'EsscarN'.'EsscarN' data connect as 'hypuser'
identified by 'password' using server rules_file 'dSales' on error
write to 'C:/book/dataload.err';
/* This statement loads the
data into the Cube */
logout;
/* logs out users session */
exit;
/* Exits from Maxl */
Save the file with the
.mxl
extension then open the Command Prompt and run
your MaxL script
from the prompt as shown in the following screenshot.
If you type
ESSMSH
in the command prompt and the MaxL prompt
does not show up, then go to the
Environment Variables
and add
the path below:
<Hyperion-home>\AnalyticServices\bin\essmsh.exe.
After you add this into the path, you will be able to run MaxL from
anywhere in the DOS prompt.
