Production Reporting Execute Dialog Box

The Production Reporting Execute dialog box allows you to run a precompiled Production Reporting program. It also connects you to the database. The database you use must be active and accessible.

Note:   The information in this dialog box varies according to the database you are using.

Report Name
Specify the name of the Production Reporting report to open using one of the following options:

•

Click the Files button to select a Production Reporting report from any of your drives or directories.

•

Type in the report name.

When you type in the report name, you must enter the entire path to the report. For example, to open a report titled test.sqr, you could enter:
c:\hyperion\BIPlus\bin\SQR\Server\db2\test.sqr

•

Click the arrow to the right of the field and select a report from the list that appears.

The reports that appear in the list are the reports you most recently opened. Up to five reports can appear. If you chose to save parameters when you initially saved the report (see Save Parameters below), Production Reporting enters the appropriate information (username, database, report arguments) in the remaining dialog box fields.
Note that it is possible to have more than one entry with the same report name. For example, assume you run a report titled test.sqr. Assume further that you run the report again, but this time you change the report arguments. In this case, test.sqr will appear in the drop-down list two times.
Username
Enter your database username.
Password
Enter your database user password.
Database (Oracle, DB2, Informix)
Enter a database to log onto. For example:
hyperiondb
DataSource (ODBC, DDO)
Enter a datasource to log onto.
Report Arguments
Enter any desired Report Parameters.
Save Parameters
Select this option to save the information entered in the dialog box along with the report. When you later open the report, all of the information (with the exception of the password) will appear in the dialog box. Saving parameters along with a report saves you from having to enter database information and report arguments each time you open a report.