Set Output Options

Each scheduled job can have multiple output files with distinct characteristics. Each output file can have multiple destinations.

The Output tab has two regions: Output and Destination.
  1. Select the Output tab.
  2. Select the output options required for the job.
    • Select Use Bursting Definition to Determine Output and Delivery Destination to use the report bursting definition for output and delivery. If you select this option, all other fields on this page are disabled for selection. This option is only available when bursting is enabled for the report.
    • Select Use XML Data Chunking to chunk XML data for processing large reports. If you select this option, the job can have only one output. This option is available only if you've enabled XML data chunking for the report.
    • Select Enable XML Pruning to prune large non-binary datasets. This setting isn't affected by the setting to prune XML data in the data model.

      XML data pruning isn't supported for:

      • XPT template
      • Bursting reports
      • Chunking XML data
    • Select Make Output Public to make this job output available to all users with permission to access this report. Users with access can view the report from the Report Job History page.
    • Select Save Data for Republishing to save the XML data that is generated for this job. Access the saved data from the Report Job History page where you can republish it, selecting a new layout and output options.
    • Select Compress output prior to delivery to compress each report (all report formats except HTML) before delivery. The format for the file name of each compressed report is Name_Output Format.zip. For example, if the delivery destination is email for Order.pdf and Invoice.xlsx reports, the order_PDF.zip and Invoice_XLSX.zip reports are attached to the email.

      Supports email, HTTP, Content Server, and Documents Cloud Service (Oracle Content Management) delivery channels.

      In the Report Job History page, if you view the details of a job that was configured with the Compress output prior to delivery option, and then click Send in the Output & Delivery section, the delivered output isn’t compressed.

Add Destination Types to Report Output

Enter delivery details in the report’s Destination region to deliver a report to multiple destinations.

Administrator must set up the delivery servers in the Administration page.
  1. From an existing report in the Report Viewer, select Actions, and then select Schedule.
  2. In Schedule Report Job, click the Output tab.
  3. In the Output tab, open Destinations, and from the Destination Type list, choose a destination type.

    Only those destination types set up by your administrator are displayed in the Destination Type list.

  4. For each destination, from the Output list, select the documents to send to the destination.
  5. Click Add Destination to deliver a report document to multiple destinations.
  6. Select Save Output to view the output from the Report Job History page.

Report Output Destination Types

Select and define the destination types for your report’s output in the Schedule Report Job page.

Only the destination types configured by the administrator are available for selection. You can add multiple destinations for the report’s output.

Destination Type Description
Email

Enter multiple email addresses separated by a comma.

Enter any message text to include with the report. To format the message text, you can use HTML 4 elements such as fonts, lists, table cells, hyperlinks, and embedded GIF images.

Use these options to configure a notification for email receipt and email read.

  • Request Delivery Status Notification

    Select this option to email a notification message to the sender when the email delivery is successful, delayed, or failed.

  • Request Read Receipt

    Select this option to email a notification message to the sender when the recipient opens the email message.

Printer

Select the printer group and the printer, enter the number of copies, and then select single sided or double sided (the printer must support duplex printing for this option to take effect). Optionally, select the printer default tray from which to print the report, and the print range pages.

Fax

Enter the fax number to which to send the report.

FTP

Skip the username and password fields to use the FTP delivery settings configured by the administrator. Only if you want to override the configuration of the FTP server and use password-based authentication, enter the valid username and password credentials for the FTP server.

Specify the following properties:

  • Remote Directory

    (Required) Enter the delivery directory location, for example, /pub/.

    To deliver the document to the user's home directory, enter . (period).

  • Remote File Name

    (Required) Enter the file name for Publisher to assign to the delivery document on the remote server, for example, myreport.pdf.

    You must include the file extension in the name, for example, .pdf .

    You can assign a file name dynamically using a date expression.

Content Server

Select the content server and the destination folder.

To limit access to the report on the content server, assign a Security Group and Account to the report. Publisher retrieves the Security Group and Account values configured for the content server.

Content and Experience

Select the Oracle Content Management server and the destination folder.

Object Storage Select the Object Storage where you want to deliver the report, enter the prefix text, and the file name for the report. The prefix helps in organizing the reports in the Object Storage. When you want to download the report output from an Object Storage, the prefix helps you identify the reports.

Prefix defines the folder path in Object Storage. You can provide an existing prefix or a new prefix. You can use job ID or report name as the prefix. If you don't provide a prefix, BIP is used as the prefix by default.

Content Server Destination Type Properties

Content Server is one of the destination types to deliver your report document. Select the content server where you want the report delivered.

Use the information in this table to enter appropriate values for the Content Server properties.

Property Name Description
Security Group (Optional) Select the Content Server security group to assign to the report.
Account (Optional) Select an account within the Security Group to assign to the report.

You can enter values for the following required metadata fields. If you don't enter values for these fields, the values from the default report information apply.

Author (Optional) Enter the name of the report's author. you leave this field blank, your user ID is used for the Author metadata field on the Content Server. If the administrator selected Use Logged in user as Author for the Content Server, Publisher sets the logged in user as the author in the Author metadata field on the Content Server.
Title (Optional) Enter a title for the report. If you don't enter a title, the layout name is used for the title on the Content Server.
File Name Enter the file name to assign to the delivered document on the remote server, for example, myreport.pdf. The file name is used as the Native File Name on the Content Server. If you don't supply a file name value, the Output name is used.
Comments (Optional) Enter a description to include with the document on the Content Server.
Include Custom Metadata

The Include Custom Metadata option is only available if the data model for the report includes a Custom Metadata component. When you select the Include Custom Metadata option, the delivered document includes the custom metadata fields specified in the data model.

When you can configure an embedded parameterized report to display online, the parameters display the appropriate values from an analysis or a direct connection to a subject area. When you schedule a an embedded parameterized report, the parameters from the analysis aren't passed to the report. As a result, the report displays default values of the parameters used in the analysis. For a direct connection with a scheduled report, the parameters are passed and the values are displayed correctly in the report.

Add Outputs

You can create multiple report documents for one or more layouts using a combination of output format, locale, time zone, and calendar.

  1. From an existing report in the Report Viewer, select Actions, and then select Schedule.
  2. In Schedule Report Job page, click the Output tab.
  3. In the Output tab, click + to add an output.
  4. In Name, type a name for the output.
  5. Select the options to use from the Layout, Format, Locale, Timezone, and Calendar lists.
    • For Output Format, specify the type of document generated such as PDF, HTML, or XLS. The available outputs are specified in the report definition.

    • For Locale, the locale defaults to the Report Locale defined in the user Preferences. If the layout doesn't have an available translation for the selected locale, Publisher applies a locale fallback logic to select the layout. The appropriate number and date formatting are applied independently of the template translation.

  6. Click Save Output.