You can log into the MaxL Shell for interactive use (typing statements at the keyboard) in the following ways. See MaxL Invocation Summary for more descriptions of login flags.
-u, -p, and -s Flags: Login Prompts and Hostname Selection
Invoked without a flag, file name, or arguments, the MaxL Shell starts in interactive mode and waits for you to log in. Note to Windows users: This is the same as double-clicking essmsh.exe, located in the ESSBASEPATH\BIN directory.
essmsh
Essbase MaxL Shell - Release 11.1.2
Copyright (c) 2000, 2010, Oracle and/or its affiliates.
All rights reserved.
MAXL> login Fiona identified by sunflower;
49 - User logged in: [Fiona].With the -a flag, the MaxL Shell starts in interactive mode and accepts space-separated arguments to be referenced at the keyboard with positional parameters.
Note: | If interactive arguments are used with spooling turned on, variables are recorded in the log file just as you typed them (for example, $1, $2, $ARBORPATH). |
essmsh -a Fiona sunflower appname dbsname Essbase MaxL Shell - Release 11.1.1 Copyright (c) 2000, 2008, Oracle and/or its affiliates. All rights reserved. MAXL> spool on to 'D:\output\createapp.out'; MAXL> login $1 identified by $2; 49 - User logged in: [Fiona]. MAXL> create application $3; 30 - Application created: ['appname']. MAXL> create database $3.$4 as Sample.Basic; 36 - Database created: ['appname'.'dbsname']. MAXL> echo $ARBORPATH; C:\Hyperion\products\Essbase\EssbaseClient MAXL> spool off;
Contents of logfile createapp.out:
MAXL> login $1 identified by $2;
OK/INFO - 1051034 - Logging in user Fiona.
OK/INFO - 1051035 - Last login on Friday, January 18, 2008 4:09:16 PM.
OK/INFO - 1241001 - Logged in to Essbase.
MAXL> create application $3;
OK/INFO - 1051061 - Application appname loaded - connection established.
OK/INFO - 1054027 - Application [appname] started with process id [404].
OK/INFO - 1056010 - Application appname created.
MAXL> create database $3.$4 as Sample.Basic;
OK/INFO - 1056020 - Database appname.dbname created.
MAXL> echo $ARBORPATH;
C:\Hyperion\products\Essbase\EssbaseClient
MAXL> spool off;When the -l flag is used followed by a user name and password, the MaxL Shell logs in the given user name and password and starts in interactive or non-interactive mode. The user name and password must immediately follow the -l, and be separated from it by a space.
essmsh -l Fiona sunflower
Entered at the command prompt, this starts the MaxL Shell in interactive mode and logs in user Fiona, who can henceforth issue MaxL statements at the keyboard.
The MaxL Shell can be invoked using -u and -p options in interactive mode, for passing the user name and password to the shell upon startup. To be prompted for both username and password, use the -s option with the host name of the Essbase Server.
If -s <host-name> is passed to the shell, MaxL will prompt for the user name and password, and the password will be hidden.
Example:
essmsh -s localhost Enter UserName> admin Enter Password> ******** OK/INFO - 1051034 - Logging in user admin. OK/INFO - 1051035 - Last login on Monday, January 28, 2003 10:06:16 AM. OK/INFO - 1241001 - Logged in to Essbase.
If -u <username> is passed to the shell and -p <password> is omitted, MaxL Shell will prompt for the password, and the password will be hidden.
Example:
essmsh -u user1 Enter Password > ******
If -p <password> is passed to the shell and -u <username> is omitted, MaxL Shell will prompt for the user name.
Example:
essmsh -p passwrd Enter Username > user1