20 Manage Essbase Using the MaxL Client
MaxL is a multi-dimensional database access language for Essbase.
To run MaxL scripts or statements, you must use the MaxL Client to issue the statements over HTTP or HTTPS.
Prerequisites to Set Up the MaxL Client
Complete these tasks before you download and use the MaxL Client. To execute MaxL scripts or statements, you must be a power user or administrator.
Download and Use the MaxL Client
The Essbase MaxL Client enables you to use MaxL over HTTP or HTTPS. MaxL is an administrative, language-based interface for managing cubes and artifacts. This alternative to the CLI can be useful if you already have a library of MaxL scripts. Be sure you are using the latest client version provided in the Console, as older, previously downloaded versions may not work correctly.
To run MaxL statements, you must be a power user or an administrator. Before you download the MaxL Client, see Prerequisites to Set Up the MaxL Client.
-
In the Essbase web interface, click Console.
-
In the Console, go to MaxL Clients.
-
Click Download next to the MaxL Client that is appropriate for your platform.
-
Save the compressed
EssbaseMaxl
file to your local drive. -
Extract the contents of the compressed file to a folder.
-
If you’re using a proxy, you must set or unset the correct proxy in the MaxL execution script,
startMAXL.bat
orstartMAXL.sh
. Here are examples using bash:export https_proxy=http://proxy.example.com export no_proxy=127.0.0.1,localhost,something.something.com
-
Run the
startMAXL
batch or shell script. A command prompt opens, the environment setup completes, and the MaxL Client starts up. -
Log in by providing your service credentials and discovery URL in the MaxL login statement.
For example:
login admin1 password1 on "https://myEssbase-myDomain.analytics.us2.oraclecloud.com/essbase/agent";
-
Execute an interactive MaxL statement.
For example:
display database all;
To learn more about MaxL, see MaxL Statement Reference in Technical Reference for Oracle Analytics Cloud - Essbase.