After you create and save a report script, you must execute the script to generate the report. To check syntax before executing a report script, open the script in Report Script Editor and click the Check Syntax button.
To work in the console as a report script processes, you can execute the report script in the background. When you execute a report script in the background, you can check its status and view the generated report from the Background Process Status window.
Note: | When executing a report script that incorporates the WIDTH command, Administration Services sets the column width one character smaller and truncates the excess. For example, a script with WIDTH equal to 7 will set the displayed column width to 6. You must edit the script to compensate. This is a known issue. |
You can specify whether Essbase always executes report scripts in the background or whether you are prompted each time you execute a script. For more information, see Setting Essbase Default Options.
To execute a report script:
Perform an action:
Essbase displays the Execute Report Script dialog box.
If you are executing a script that is saved to the file system or is saved at the application level rather than at the database level, select the database against which to execute the report script.
To execute the report script in the background, select Execute in the background.
Select one or more destinations for the report (console, printer, or file).
Click OK.
Essbase runs the report script against the appropriate database. Errors and status messages are displayed in the Messages pane along the bottom of the console window. The report is sent to the selected destinations.
If you execute a report script in the background, an ID for the process is displayed. You can use the ID to track the status of the process. When the process is completed, you can view the report from the Background Process Status window.
export database (MaxL) in the Oracle Essbase Technical Reference
runreport (ESSCMD) in the Oracle Essbase Technical Reference