Tutorial
Practice
Bookmark
Prev
Next
 
 
     
 
AXIS Script is based on a large subset of VBA (Visual Basic for Applications) and accordingly, experienced users of VBA should find most commonly used VBA elements supported consistently in AXIS Script.  However, users should be aware of specific interface issues, writing and debugging tools, and restrictions in AXIS Script, as described in the documentation provided.

In each AXIS object which utilizes AXIS Script, the user is expected to create a small program or procedure (a "formula") which either defines a specific set of numeric values (e.g. the specific assumptions provided through a Formula Table) or a defines a production batch procedure controlling the execution of AXIS processes and calculations (e.g. an AXIS System Formula).  For each such object, the AXIS Script Editor is the interface used to write and maintain this formula.  There is also an AXIS Script Debugger which allows the user to track the values of intermediate variables as the Formula is being executed as part of AXIS calculations, in a controlled step-wise manner.   

The user is responsible for learning and using basic programming techniques, such as naming and declaring his own variables for storing intermediate values, and the creation and use of user defined subroutines and subfunctions, as appropriate.  In addition to a large library of predefined functions that are vendor provided, there are also predefined sets of input variables available for the programmer to use (specific to each formula object), and predefined output variables that can be used in subsequent AXIS calculations, all of which are documented in the Help text for the specific Formula Table being defined.

AXIS Script is written in a free-form text window.  The editor automatically recognizes and colour codes statements and other supported language elements, according to their type.  If words in the written procedure are not colour coded, they are presumed to be either operators, constants or variables, which thus provides feedback to the programmers as to possible syntax errors.  Tooltips also help explain the expected syntax of parameters on each vendor supplied function.  Prior to actually using a Formula Table in a Cell recalculation, you may ask AXIS to precompile the formula which allows detection and correction of syntax errors that would otherwise halt the Cell calculation.  Error messages will identify the location of the syntax error in the code.  The editor also allows you to preset multiple breakpoints which will halt the execution of the code to reveal intermediate calculated values and thus confirm the validity and correctness of more complex coded procedures. 

Programmers should use traditional good programming practices such as using meaningful variable names for user defined local variables, indenting lines within nested loops to reveal the structure of code, and liberal use of comments statements within the code itself.

   
Prev
Next