What is a MaxL scripts in Essbase?

Posted on by Muna Meyer

What is a MaxL scripts in Essbase?

Maxl is a multidimensional database access language that is part of Essbase – Servers provides a flexible way to automate Essbase administration and maintenance tasks. A MaxL Shell script can be executed from: a shell of another scripting language.

How do I create an Essbase MaxL script?

Creating MaxL and MDX Scripts

  1. Write a MaxL script using a text editor. Here is an example MaxL script: Copy alter system enable unicode; create or replace application “ASOmaxl” type unicode_mode using aggregate_storage; create or replace database “ASOmaxl”.
  2. Save the script file locally with a . msh extension.

How do I run a MaxL script?

To execute a MaxL script or an MDX script:

  1. Open or create the script.
  2. From the server drop-down list on the toolbar, select the Essbase Server to execute the script against. The drop-down list contains only Essbase Servers that are displayed in your Enterprise View.

How do I log into Essbase MaxL?

Log in by providing your service credentials and discovery URL in the MaxL login statement. For example: Copy login admin1 password1 on “https://myEssbase-myDomain.analytics.us2.oraclecloud.com/essbase/agent”; Execute an interactive MaxL statement.

How do I run a MaxL script using Essbase MaxL client?

Download and Use the MaxL Client

  1. In the Essbase web interface, click Console.
  2. In the Console, go to MaxL Clients.
  3. Click Download.
  4. Save the compressed EssbaseMaxl file to your local drive.
  5. Extract the contents of the compressed file to a folder.
  6. Run the startMAXL batch or shell script.

How do I start MaxL?

Just go to cmd, type essmsh following by the location and maxL name (f.e. c:test. mxl): essmsh c:test. mxl.

How do you use MaxL Essbase?

What is Maxl in Essbase?

MaxL is the multi-dimensional database definition language (DDL) for Essbase Server. Using MaxL, you can easily automate administrative and query operations on Essbase Server. A MaxL script contains a login statement and a sequence of MaxL statements, each terminated by a semicolon.

What is a Maxl shell script?

Maxl is a multidimensional database access language that is part of Essbase – Serversprovides a flexible way to automate Essbase administration and maintenance tasks. A MaxL Shell script can be executed from: the Essbase – Maxl Script Editorin Essbase – Administration Services Console the DOS Command Line a shell of another scripting language

What is the login statement in Maxl script editor?

If you use MaxL Script Editor to execute a MaxL script, the login statement is optional; you can select the Essbase Server that you want to connect to from the editor. Most MaxL statements begin with a verb and consist of grammatical sequences of keywords and variables.

How to automate Essbase in daily maintenance job?

MAXL is such a script language that can use to automate essbase in daily maintenance job by using some batch script to do it automatically, instead of use the admin console every time to add new member or execute calculation on the database. We can write MaxL scripts which are easy to customize and re-use.