Databases Reference
In-Depth Information
Essbase MaxL scripts
MaxL is a Multidimensional Access Language developed for Essbase analytics. MaxL,
as it is known, is a powerful scripting tool developed for the system administrator of
Essbase to perform administrative tasks from the creation of a new user, to adding
new security filters, to updating the database outline, to importing data, to executing
calculation scripts, and finally to the deletion of a database or an application.
These tasks are very important to do, but remember, if you make a mistake in one
of these scripts your entire database cube and all of the data can be lost. Please use
extreme caution while executing MaxL statements.
MaxL statements are case sensitive and must always end with a semi-colon.
MaxL supports most of the tasks and functions that you can perform in the EssCmd
scripting language and it also supports all of the new functionalities that have been
added to the newer versions of Essbase. EssCmd is used extensively in the older
versions of Essbase and MaxL is highly recommended for the newer versions of
Essbase. EssCmd does not support some of the newer features like ASO and Essbase
database security filters.
The MaxL scripting language uses a statement construct syntax which has its
own grammar. Every MaxL statement consists of verbs and objects.
Some of the verbs used in a typical MaxL statement are:
• Alter
• Create
• Display
• Drop
• Execute
• Import
• Export
• Grant
• Query
• Refresh
Some of the objects used in a MaxL statement are:
• Application
• Database
• Dimensions
