Scheduling Reports in Query Report Scheduler

Access the Query Report Scheduler page (Select Reporting Tools, and then BI Publisher, and then BIP Query Report Scheduler.)

This example illustrates the fields and controls on the Query Report Scheduler page. You can find definitions for the fields and controls later on this page.

Query Report Scheduler uses the existing Process Scheduler functionality to:

Select runtime parameters for query-based, connected query-based, or composite query-based reports.
Monitor the report process request.
Post and secure the results to either the Report Manager, a printer, or the Process Scheduler file directory.

Note:

If a query is run through Reporting Tools, and then Query, and then Schedule Queries the BI Publisher-related prompts do not appear. Only the basic table-formatted query results are generated.

Field or Control	Description
Run Control ID	Enter a run control ID.
Language	Indicates the language of the run control. The report selects data and template translations based upon the language code of the run control. The user sets this value on the My System Profile, and then General Profile Information page in theMy Preferred Language for Reports and Email field. The language appears in the Query Report Scheduler Search Results so that you are informed of the language selection criteria.
Data Source Type	Select either Query, Connected Query, or Composite Query.
Report Name	Select the name of the Query, Connected Query, or Composite Query-based report that you want to schedule. The drop-down list box values are based on previously registered report definitions. Existing Query security applies so that each user has access to run only reports to which they have Query access.
Burst Field Name	Displays the value set in the Burst by field of the Report Definition, Bursting page. This field appears for bursted reports only.
Dynamic Template	Displays either Active or Inactive, depending on whether criteria exists to dynamically select the template, language, or both based upon a data value that is set in theTemplate group box of the Report Definition, Bursting page. This field appears for bursted reports only.
Bursting Security	Displays either Active or Inactive, depending on whether criteria exists to assign unique bursting security that is set in theBurst Security group box of the Report Definition, Bursting page. This field appears for bursted reports only.
Template ID	Select from the templates associated with the report definition.
Template As Of Date	(Optional) Select the as of date for the template version to use for the report. The system looks at the report definition for templates that are active as of this date.
Channel	Indicates the distribution channel of the template.
Update Parameters	Click to update the Query, Connected Query, or Composite Query runtime prompt values. After runtime values are entered, they are saved with the run control ID.
Report Manager	Click to go to the Report Manager to check the progress of your process request and to view the report content immediately after the output file is posted. The final output file is posted to the Report Manager repository for web access by authorized users. See Process Scheduler: Viewing Reports.
Process Monitor	Click to go to the Process Monitor to check the progress of your request. See Process Scheduler: Understanding Process Monitor.
Run	Click to access the Process Scheduler Request page. The Process Scheduler Request page enables you to specify variables, such as where a process runs and in what format the process output is generated. The values for output type and output format appear by default per the report definition and can be changed if the report definition allows it. Distribution options are also active, allowing updates to viewers, only as allowed in the report definition.
Go to BIP Report Search	Click to access the BIP Report Search page. See Searching the BI Publisher Report Repository.

See Process Scheduler: Submitting Process Requests and Process Scheduler: Scheduling Process Requests.