A report script comprises a series of Report Writer commands, terminated by the bang (!) report output command.
You can enter one or more report scripts in a report script file, which is a text file that you create with Report Script Editor or any text editor.
To build a report script, enter or select commands that define the layout, member selection, and format in Report Script Editor. The different elements of a script are color-coded to aid readability. You can enable syntax autocompletion to help build scripts quickly.
The commands in Report Writer perform two functions, data extraction and formatting:
Extraction commands deal with the selection, orientation, grouping, and ordering of raw data extracted from the database. These commands begin with less-than signs (<).
Formatting commands allow customization of the report format and appearance, the creation of new columns, and calculation of columns and rows. These commands are generally contained within braces ({ }), although some begin with less-than signs (<).
The bang character (!) terminates a series of commands and requests information from the database. You can place one or more report scripts, each terminated by its own ! command, in the same report file.
For information about report commands, see the Oracle Essbase Technical Reference.