Viewing Scheduled Workbooks

Scheduled workbooks run at a specified time. For example, you might want to run a workbook at the end of each month that calculates monthly profits from monthly sales figures, or you might want to run a workbook every two weeks based on a biweekly cash-flow analysis.

Often, workbooks that you want to schedule are designed specifically for that purpose, rather than for your day-to-day analysis. For example, the workbook might include special calculations or Conditions that produce the results you want on a periodic basis only.

See your Discoverer Administrator to schedule a workbook. You must have appropriate privileges to schedule a workbook.

Typically you schedule workbooks if:

• The workbook will take a long time to run; scheduling a workbook to run at night or on the weekend avoids overburdening the server during business hours.

• You want to run a workbook at regular intervals, such as a weekly report of sales figures or a monthly cash-flow analysis.

Because a scheduled report runs on the server, you do not need to leave your computer on overnight (or whenever you schedule the report to run). The results of the scheduled report are saved on the server and are available when you connect to the database and start Discoverer.

A scheduled workbook produces a worksheet or set of worksheets with the results derived from running the workbook. You can open a scheduled workbook when you start Discoverer, or while working in a workbook. If you run a scheduled workbook overnight (or over the weekend) and want to see the results first thing the next morning, open the workbook as you connect to Discoverer.

Viewing Scheduled Workbooks when connected as an Oracle Applications User

When connected as an Oracle Applications User, the following rules apply:

• If you connect as a particular User and Responsibility and schedule a Workbook, the Scheduled Workbook is specific to that User and Responsibility.

• If you connect as a particular User but a different Responsibility from the one used to schedule a Workbook, the Scheduled Workbook may contain different results from the original Scheduled Workbook that was created.

To open a scheduled workbook:

1. Do one of the following:
   • Connect to the database and launch Discoverer as described in Section , "Opening an Existing Workbook".

   • If you are already connected to the database, from the menus choose
     File | Open. The Open Workbook dialog appears.

2. Click Scheduled and click Open. The dialog lists the scheduled workbooks.

   
   

3. Select the scheduled workbook you want to see and click Open.

NOTE: The worksheets produced by running the scheduled workbook contain data derived specifically for that report and you can work with the worksheet in the normal manner. But if you change any of the data, a message reminds you that the new data on the worksheet is not the same as that derived from the scheduled workbook.