MAXL DDL Language in Essbase

MaxL is a flexible way to automate Analytic Services administration
and maintenance tasks. The MaxL data definition language is an interface for making
administrative requests to Analytic Services using statements. You can Write MaxL
scripts with variables to make them customizable and re-usable.

Overview of Statements

MaxL statements always begin with a verb, such as create or alter. Verbs
indicate what type of operation you want to perform.

Follow the below steps to build dimensions:

Before working on MaxL commands, make sure the source file is ready and rules
file is working. Test the rules file manually.
Open a notepad and type the below MaxL commands, save the file with .msh
extention.


***********************************************************************

spool on to 'c:\\batch\prodlog.log';
login selfbitech on sree;

import database sales2.sales2 dimensions from data_file
'c:\\batch\prod.txt' using server Rules_file prod on error write to
'c:\\batch\proderr.err';

logout;
exit;

************************************************************************

Open another notepad and write the below commands. Save the below file with .bat
extension if it is windows and save the file with .sh extension if the file is unix.

*************************************************************************
ESSMSH c:\\BATCH\PROD.msh
*************************************************************************

MAXL commands can also be used to create the application, database, users etc.

Steps to use this script

->Create Source file
->Create rules file.
->Manually update and test the outline.
->write a maxl script.
->Test the Maxl manually.
->open another note pad and write ESSMSH MAXL filename
->Run batch file manually.
->Schedule the batch file.
Executing calculation

Execute calculation default on 'sales2'.'sales2';
If any calculation script is there like calc1
Execute calculation 'sales2'.'sales2'.calc1;