Regular statements are typically used for manipulating data in one way
or another. These statements may be written over any number of lines in
the script and must always
be terminated by a semicolon, ";".
All script keywords can be typed with any combination of lower case and upper case characters. Field and variable names used in the statements are however case sensitive.
Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.
In a chart modifying context, the LOAD statement loads additional data to the hypercube from data defined in the script, or from a previously
loaded table. It is also possible to load data from analytic connections.
Information noteThe LOAD statement must have either Replace or Add prefix, or it will be rejected.
The let statement is a complement to the set
statement, used for defining script variables.
The let statement, in opposition
to the set statement, evaluates
the expression on the right side of the ' =' at script run time before it is assigned to
the variable.