Oracle Analytics Publisher Report Scheduling

Recovery Appliance provides the following pre-created Oracle Analytics Publisher (OAP) reports, formerly BI Publisher:

Oracle recommends that you configure OAP to generate reports automatically on a regular schedule (for example, every week), and to send the reports by email to the backup management team. You can also generate reports as needed using the techniques described in this chapter.

To schedule a report for the Recovery Appliance in OLP:

  1. In OLP catalog, navigate to where the Recovery Appliance reports are: Shared Folders -> Enterprise Manager Cloud Control -> Recovery Appliance Reports.

  2. Of the reports listed, each has actions listed under their descriptions: Open, Schedule, Jobs, Job History, and more.

  3. For a given report underneath its description, select the Schedule action.

    .
  4. The Schedule Report Job page has several screens of information.

    • General tab: provides the path to the report and a drop down to select the Recovery Appliance that the report is run against.

    • Output tab: provides checkboxes for Make Output Public, Save Data for Republishing, and Compress output prior to delivery. The Output area defines the name, format (HTML, PDF, Excel .xlsx), locale, time zone, etc. for a given output product. The Destinations area defines where the reports are sent.

    • Schedule tab: provides controls for determining the job frequency, if it should be run now or at some future time. The Use Trigger allows you to conditionally run an occurrence of the job. When the scheduled time occurs, the trigger is checked. If the trigger returns data, the job proceeds; if not data is returned, the job is skipped. Additional controls are can be established for the trigger, such as retry limit, pause time, etc.

    • Notification tab: shows the email or HTTP servers to receive the generated report.

    • Diagnostic tab: displays checkbox items several diagnostic tools: Enable SQL Explain Plan, Enable Data Engine Diagnostic, Enable Report Processor Diagnostic, Enable Consolidated Job Diagnostic

See Also:

Configure the Scheduler to learn how to schedule reports with Oracle Analytics Publisher in Oracle Analytics Server.