Manage Essbase Using the MaxL Client

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.

To prepare for using the MaxL Client,

Get the URL for the Essbase instance from your Service Administrator. Its basic format is:
```
https://essbase-instance-name.oraclecloud.com/essbase
```
Using a web browser or cURL, test that you can reach the discovery URL from the client host. Here is a cURL example:
```
curl https://myEssbase-myDomain.oraclecloud.com/essbase/agent --tlsv1.2
```
Set up the SSL certificate, if applicable to your organization.
- If you’re using one of these deployment types, a Trusted CA Signed SSL Certificate is included:
  - Oracle Analytics Cloud
  - Oracle Analytics Cloud with Identity Cloud Service (IDCS) and Load Balancing
  - Cloud at Customer with Load Balancing
- If you’re using Oracle Analytics Cloud or Cloud at Customer with LDAP (without Load Balancing), use a self-signed certificate.
To check if a certificate is trusted, paste the discovery URL into a web browser. If https is green or a label says “Secure,” it is trusted. If https is red or a label says “Not secure,” it is untrusted.
If the certificate is untrusted (self-signed), import it to the client trust store (cacert.pem).
The client verifies the server’s digital certificate using a provided ca-bundle certificate store. Provide the ca-bundle location by specifying the environment variable:
API_CAINFO=CA certificate file path;

If the path is not provided, the Essbase Runtime Client will try to get ca-bundle from the default OpenSSL installation location (applicable for Linux and Macintosh).
Oracle Data Visualization clients and MaxL Client include a ca-bundle (cacert.pem).

If you need a ca-bundle (cacert.pem), you can also download it. One sample source is: https://curl.haxx.se/docs/caextract.html.

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 or startMAXL.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.