You use the Execute Report Script dialog box to select a database against which to execute a report script.
The look of the dialog box varies, depending on whether you are executing a script that (1) was opened from the file system, (2) is associated with an application but not with a database, or (3) is associated with a database.
If the script that you are executing is saved on the file system, not onEssbase Server, the following boxes are displayed. In this case, you select the items that specify your preferred database:
Essbase Server
Application
Database
In the dialog box, you can select one or more of the following options. However, if you select the Execute in the background option, you cannot select the Console or Output file option.
Execute in the background—As the process executes, you can continue working. Also, you can exit the console but you cannot shut down Essbase Administration Server. You can check process status in the Background Process Status window.
Console—The report is displayed in the Report Viewer window in Administration Services Console.
Printer—The report is sent to the selected printer. If Execute in the background is selected, the report is sent to the default printer for the Essbase Administration Server computer.
Output file—The report is sent to an output file (.rpt). You can click the Find button to browse to the preferred file.
export data (MaxL) in the Oracle Essbase Technical Reference
runrept (ESSCMD) in the Oracle Essbase Technical Reference