Databases Reference
In-Depth Information
Running calc using a MaxL script
How can we forget MaxL? There is no way we can forget MaxL. MaxL is the new
generation of command scripting language used by Essbase. If you look closely
at the MaxL statements, you will see that they are very close to your typical SQL
statements. Since you will be exporting data, you will use the
EXPORT
MaxL
statement to run the report script.
Syntax:
EXPORT DATABASE database name USING LOCAL/SERVER REPORT_FILE report
script name TO DATA_FILE output data file name.
Code:
export database 'ESSCAR'.'ESSCAR' using server report_file 'Test' to
data_file 'c:/book/test.rpt';
This code, when executed from MaxL, will execute the
Test.rep
against the
ESSCAR
application/
ESSCAR
database.
To create a MaxL script file object, simply open the
MaxL Script Editor
in the EAS
tool by clicking the
Editors
menu pick, then click on
MaxL Script Editor
. The
MaxL
Script Editor
is shown in the following screenshot:
You can execute the script by clicking on the
Execute Script
button on the MaxL menu
or on the
EAS | Execute
on the EAS menu or press
F5
to execute the script. Once the
script is executed, you will see the
validation_6.rpt
file in the location specified.