Databases Reference
In-Depth Information
Working with database calculations in MaxL
Using MaxL you can also create database calculation files, display the list of calc files,
drop calc files, and execute calc files.
Create calculation
MaxL statements let you create a new calc file or copy an existing calc file from
another application on the server.
Syntax:
create calculation <Calc-name> <Calc-string | as calc-name>
Code Sample:
create calculation 'ESSCAR'.'ESSCAR'.'ESSCALC' 'CALC DIM(PRODUCTS,
MARKETS)'
Upon execution of the above code a new calc script named
ESSCALC
will be created
within the
ESSCAR
application.
Display calculation
The
display
MaxL statement will display the calculation scripts on the
analytic server.
Syntax:
display calculation <all | <Calc-name> | on application <App-name>
| on database <Db-Name>>;
Code Sample:
display calculation all;
display calculation on application 'ESSCAR';
Execute calculation
The
execute calculation
MaxL statement will run the specified calc script.
Syntax:
execute calculation < Calc-name > | Calc-name on database Db-String
| Calc - String on Db-Name | default.;