Report Writer consists of three main components:

• Report Script Editor is a text editor that you use to write report scripts. Report commands define formatted reports, export data subsets from a database, and produce free-form reports. Execute the saved script to generate a report. Saved report scripts have the file extension .rep.
• Report Extractor retrieves data information from the Essbase database when you run a report script.
• Report Viewer displays the complete report. Saved reports have the file extension .rpt.

Note: Replace G with "less than" symbol

Report Extractor
The Report Extractor processes the report script and retrieves data, performing the following
actions:
1. Composes the member list, based on all possible member combinations. For example, GIDESCENDANTS East retrieves member East and all of its descendants:
2. Applies member restrictions. For example, GLINK refines the member selection:
3. Orders the member output. For example, GSORT determines the order in which members are sorted:
4. Extracts data from the following areas:
     ● Local regions
     ● Partitioned regions
     ● Dynamically calculated data
5. Restricts data. For example, the following command suppresses the display of all rows that
contain only missing values:
{SUPMISSINGROWS}
6. Sorts data. For example, GTOP returns rows with the highest values of a specified data column:
7. Formats output. For example, {SKIP} skips one or more lines in the final output report:

The order in which Report Extractor retrieves data affects the execution of complex extraction

and formatting commands. For example, because the Report Extractor restricts data (5) before

sorting data (6), if you place conditional retrieval commands in the wrong order, report output

results can be unexpected. Be aware of the data retrieval process when designing report scripts.