Oracle® Fusion Middleware Developer's Guide for Oracle Business Intelligence Publisher 11g Release 1 (11.1.1) Part Number E18863-01 |
|
|
View PDF |
Note:
For information on debugging applications built with BI Publisher Web services, see Section 1.3, "Debugging Web Service Applications."This chapter provides details on the ScheduleService methods that you can use to interact with the BI Publisher scheduler. This includes methods for scheduling report jobs, retrieving report outputs, and managing report histories.
This chapter contains the following sections:
Section 3.15, "getAllScheduledReportHistoryInSession() Method"
Section 3.18, "getDeliveryServiceDefinitionInSession() Method"
Section 3.24, "getScheduledReportDeliveryInfoInSession() Method"
Section 3.26, "getScheduledReportOutputInfoInSession() Method"
Use the cancelSchedule() method to cancel a currently running scheduled job.
Signature
boolean cancelSchedule(String jobInstanceID, String userID, String password);
Table 3-1 Parameters for cancelSchedule() Method
Parameter | Description |
---|---|
String jobInstanceID |
The ID assigned to the instance of the job to be canceled. The jobInstanceID is a string of integers. |
String userID |
Specifies the BI Publisher user name. |
String password |
Specifies the password for the user name. |
Cancels the schedule associated with the bipSessionToken string for a given user.
For more information about in-session methods, see Section 1.2, "About In-Session Methods."
Signature
String cancelScheduleInSession(String jobInstanceID, String bipSessionToken);
Table 3-2 Parameters for cancelScheduleInSession() Method
Parameter | Description |
---|---|
String jobInstanceID |
The ID assigned to the instance of the job that generated the output. The jobInstanceID is a string of integers. |
String bipSessionToken |
The proprietary token string generated for the user by the BI Publisher server. With the bipSessionToken string, the user no longer needs to provide user credentials. The BI Publisher server can validate this token string and restore the BI Publisher server session to perform needed operation. |
Use the deleteJobHistory() method to perform a "soft" delete the historical information about a report job, as opposed to the purgeJobHistory() method, which performs a "hard" (permanent) deletion. The deleteJobHistory() method must precede the purgeJobHistory() method.
boolean deleteJobHistory(String instanceJobID, String userID, String password);
Signature
Table 3-3 Parameters for deleteJobHistory() Method
Parameter | Description |
---|---|
String instanceJobID |
The ID assigned to the instance of the job that generated the output. The instanceJobID is a string of integers. |
String userID |
Specifies the BI Publisher user name. |
String password |
Specifies the password for the user name. |
Deletes the job history associated with the bipSessionToken string for a given user.
For more information about in-session methods, see Section 1.2, "About In-Session Methods."
Signature
boolean deleteJobHistoryInSession(String jobInstanceID, String bipSessionToken);
Table 3-4 Parameters for deleteJobHistoryInSession() Method
Parameter | Description |
---|---|
String jobInstanceID |
The ID assigned to the instance of the job that generated the output. The jobInstanceID is a string of integers. |
String bipSessionToken |
The proprietary token string generated for the user by the BI Publisher server. With the bipSessionToken string, the user no longer needs to provide user credentials. The BI Publisher server can validate this token string and restore the BI Publisher server session to perform needed operation. |
Use the deleteSchedule() method to delete a scheduled job from the scheduler queue.
Signature
boolean deleteSchedule(String jobInstanceID, String userID, String password);
Table 3-5 Parameters for deleteSchedule() Method
Parameter | Description |
---|---|
String jobInstanceID |
The ID assigned to the instance of the job to be deleted. The jobInstanceID is a string of integers. |
String userID |
Specifies the BI Publisher user name. |
String password |
Specifies the password for the user name. |
Deletes the schedule associated with the bipSessionToken string for a given user.
For more information about in-session methods, see Section 1.2, "About In-Session Methods."
Signature
boolean deleteScheduleInSession(String jobInstanceID, String bipSessionToken);
Table 3-6 Parameters for deleteScheduleInSession() Method
Parameter | Description |
---|---|
String jobInstanceID |
The ID assigned to the instance of the job that generated the output. The jobInstanceID is a string of integers. |
String bipSessionToken |
The proprietary token string generated for the user by the BI Publisher server. With the bipSessionToken string, the user no longer needs to provide user credentials. The BI Publisher server can validate this token string and restore the BI Publisher server session to perform needed operation. |
Use the deliveryService() method to deliver a document from source to destination through the specified delivery channel.
Signature
String deliveryService(DeliveryRequest deliveryRequest, String userID, String password);
Table 3-7 Parameters for deliveryService() Method
Parameter | Description |
---|---|
DeliveryRequest deliveryRequest |
The DeliveryRequest object. See Section 2.3.21, "DeliveryRequest." |
String userID |
Specifies the BI Publisher user name. |
String password |
Specifies the password for the user name. |
Delivers a document associated with the deliveryRequest and bipSessionToken string for a given user.
For more information about in-session methods, see Section 1.2, "About In-Session Methods."
Signature
String deliveryServiceInSession(String jobInstanceID, String bipSessionToken);
Table 3-8 Parameters for deliveryServiceInSession() Method
Parameter | Description |
---|---|
DeliveryRequest deliveryRequest |
The DeliveryRequest object. See Section 2.3.21, "DeliveryRequest." |
String bipSessionToken |
The proprietary token string generated for the user by the BI Publisher server. With the bipSessionToken string, the user no longer needs to provide user credentials. The BI Publisher server can validate this token string and restore the BI Publisher server session to perform needed operation. |
Saves a report document into the local temporary directory of the BI Publisher server, and returns the fileID of the user for later downloads. This implementation is for performance concern in case that report data size is significant.
Signature
String downloadDocumentData(String JobOutputID, String userID, String password);
Downloads the document report associated with the jobInstanceID and bipSessionToken string for a given user.
For more information about in-session methods, see Section 1.2, "About In-Session Methods."
Signature
String downloadDocumentDataInSession(String jobInstanceID, String bipSessionToken);
Table 3-10 Parameters for downloadDocumentDataInSession() Method
Parameter | Description |
---|---|
String jobInstanceID |
The ID assigned to the instance of the job that generated the output. The jobInstanceID is a string of integers. |
String bipSessionToken |
The proprietary token string generated for the user by the BI Publisher server. With the bipSessionToken string, the user no longer needs to provide user credentials. The BI Publisher server can validate this token string and restore the BI Publisher server session to perform needed operation. |
Returns XML data used to generate a report document. It returns raw data in XML format.
Signature
downloadXMLData(String jobInstanceID, String userID, String password);
Downloads the XML data for a document report associated with the bipSessionToken string for a given user.
For more information about in-session methods, see Section 1.2, "About In-Session Methods."
Signature
String downloadXMLDataInSession(String jobInstanceID, String bipSessionToken);
Table 3-12 Parameters for downloadXMLDataInSession() Method
Parameter | Description |
---|---|
String jobInstanceID |
The ID assigned to the instance of the job that generated the output. The jobInstanceID is a string of integers. |
String bipSessionToken |
The proprietary token string generated for the user by the BI Publisher server. With the bipSessionToken string, the user no longer needs to provide user credentials. The BI Publisher server can validate this token string and restore the BI Publisher server session to perform needed operation. |
Use the getAllScheduledReportInfo() method to return information about all scheduled report jobs that match filter criteria passed through the JobFilterProperties object.
Signature
JobInfosList getAllScheduledReportInfo(JobFilterProperties filter, int beginIdx, String userID, String password);
Table 3-13 Parameters for getAllScheduledReport() Method
Parameter | Description |
---|---|
JobFilterProperties filter |
The JobFilterProperties object specifies the specific criteria for the report jobs you want to return information about. See Section 2.3.30, "JobFilterProperties." |
int beginIdx |
The starting point of the index (default is |
String userID |
Specifies the BI Publisher user name. |
String password |
Specifies the password for the user name. |
Use the getAllScheduledReportHistory() method to return information about all scheduled report histories that match filter criteria passed through the JobFilterProperties object.
Signature
JobInfosList getAllScheduledReportHistory(JobFilterProperties filter, int beginIdx, String userID, String password);
Table 3-14 Parameters for getAllScheduledReportHistory() Method
Parameter | Description |
---|---|
JobFilterProperties filter |
The JobFilterProperties object specifies the specific criteria for the report jobs you want to return information about. See Section 2.3.30, "JobFilterProperties." |
int beginIdx |
The starting point of the index (default is |
String userID |
Specifies the BI Publisher user name. |
String password |
Specifies the password for the user name. |
Use the getAllScheduledReportHistoryInSession() method to return information about all scheduled report histories that match filter criteria passed through the JobFilterProperties object and that are based on the bipSessionToken string for a given user.
For more information about in-session methods, see Section 1.2, "About In-Session Methods."
Signature
JobInfosList getAllScheduledReportHistoryInSession(JobFilterProperties filter, int beginIdx, String bipSessionToken);
Table 3-15 Parameters for getAllScheduledReportHistoryInSession() Method
Parameter | Description |
---|---|
JobFilterProperties filter |
The JobFilterProperties object specifies the specific criteria for the report jobs you want to return information about. See Section 2.3.30, "JobFilterProperties." |
int beginIdx |
The starting point of the index (default is |
String bipSessionToken |
The proprietary token string generated for the user by the BI Publisher server. With the bipSessionToken string, the user no longer needs to provide user credentials. The BI Publisher server can validate this token string and restore the BI Publisher server session to perform needed operation. |
Use the getAllScheduledReportInSession() method to return information about all scheduled reports that match filter criteria passed through the JobFilterProperties object and that are based on the bipSessionToken string for a given user.
For more information about in-session methods, see Section 1.2, "About In-Session Methods."
Signature
JobInfosList getAllScheduledReportInSession(JobFilterProperties filter, int beginIdx, String bipSessionToken);
Table 3-16 Parameters for getAllScheduledReportInSession() Method
Parameter | Description |
---|---|
JobFilterProperties filter |
The JobFilterProperties object specifies the specific criteria for the report jobs you want to return information about. See Section 2.3.30, "JobFilterProperties." |
int beginIdx |
The starting point of the index (default is |
String bipSessionToken |
The proprietary token string generated for the user by the BI Publisher server. With the bipSessionToken string, the user no longer needs to provide user credentials. The BI Publisher server can validate this token string and restore the BI Publisher server session to perform needed operation. |
Use the getDeliveryServiceDefinition() method to get the delivery service definition for a given userID and password. See deliveryService() Method.
Signature
DeliveryServiceDefinition getDeliveryServiceDefinition(String userID, String password);
Use the getDeliveryServiceDefinitionInSession() method to get the delivery service definition based on the bipSessionToken of a given user. See deliveryService() Method.
For more information about in-session methods, see Section 1.2, "About In-Session Methods."
Signature
DeliveryServiceDefinition getDeliveryServiceDefinitionInSession(String bipSessionToken);
Table 3-18 Parameters for getDeliveryServiceDefinitionInSession() Method
Parameter | Description |
---|---|
String bipSessionToken |
The proprietary token string generated for the user by the BI Publisher server. With the bipSessionToken string, the user no longer needs to provide user credentials. The BI Publisher server can validate this token string and restore the BI Publisher server session to perform needed operation. |
Use the getDocumentData() method to return the document generated by a BI Publisher scheduled job. You can use the JobOutputID returned from the scheduleReport() method to retrieve the generated report document.
Note, the getDocumentData() method returns the byte[] of a report document, while the downloadDocumentData() Method saves the report document onto BI Publisher server as a local file. The latter method returns the file ID, enabling the user to download the report document later through the Delivery Service. This is for performance concerns in cases where a report document size is quite large.
Signature
byte[] getDocumentData(String JobOutputID, String userID, String password);
Returns the byte[] of a report document based on the jobOutputID and bipSessionToken of a given user.
For more information about in-session methods, see Section 1.2, "About In-Session Methods."
Signature
byte[] getDocumentDataInSession(String jobOutputID, String bipSessionToken);
Table 3-20 Parameters for getDocumentDataInSession() Method
Parameter | Description |
---|---|
String jobOutputID |
The ID assigned to the output. The jobOutputID is a string of integers. |
String bipSessionToken |
The proprietary token string generated for the user by the BI Publisher server. With the bipSessionToken string, the user no longer needs to provide user credentials. The BI Publisher server can validate this token string and restore the BI Publisher server session to perform needed operation. |
Use the getScheduledJobInfo() method to return a JobDetail object that provides the details about a submitted job, including report parameters and other properties. This method retrieves all information stored in the database for a given jobInstanceID, userID, and password.
Signature
JobInfo getScheduledJobInfo(int jobInstanceID, String userID, String password);
Returns a JobDetail object that provides the details for the job that's associated with a given jobInstanceID and the bipSessionToken of a given user.
For more information about in-session methods, see Section 1.2, "About In-Session Methods."
Signature
JobDetail getScheduledJobInfoInSession(String jobInstanceID, String bipSessionToken);
Table 3-22 Parameters for getScheduledJobInfoInSession() Method
Parameter | Description |
---|---|
String jobInstanceID |
The ID assigned to the job instance. The jobInstanceID is a string of integers. |
String bipSessionToken |
The proprietary token string generated for the user by the BI Publisher server. With the bipSessionToken string, the user no longer needs to provide user credentials. The BI Publisher server can validate this token string and restore the BI Publisher server session to perform needed operation. |
Use the getScheduledReportdeliveryInfo() method to retrieve information about the delivery of a scheduled job output. For each scheduled Job, it could have multiple outputIDs. For each outputID, there could be multiple delivery info. See Section 2.3.35, "JobOutputDeliverysList."
Signature
JobOutputDeliverysList getScheduledReportDeliveryInfo(String jobOutputID, String userID, String password);
Table 3-23 Parameters for getScheduledReportDeliveryInfo() Method
Parameter | Description |
---|---|
String jobOutputID |
The ID assigned to the output of the job for which you want information. The jobOutputID is a string of integers. |
String userID |
Specifies the BI Publisher user name. |
String password |
Specifies the password for the user name. |
Returns a JobOutputDeliverysList object that provides the details for a given jobOutputID and the bipSessionToken of a given user.
For more information about in-session methods, see Section 1.2, "About In-Session Methods."
Signature
JobOutputDeliverysList getScheduledReportDeliveryInfoInSession(String jobOutputID, String bipSessionToken);
Table 3-24 Parameters for getScheduledReportDeliveryInfoInSession() Method
Parameter | Description |
---|---|
String jobOutputID |
The ID assigned to the job output. The jobOutputID is a string of integers. |
String bipSessionToken |
The proprietary token string generated for the user by the BI Publisher server. With the bipSessionToken string, the user no longer needs to provide user credentials. The BI Publisher server can validate this token string and restore the BI Publisher server session to perform needed operation. |
Use the getScheduledReportOutputInfo() method to return information about a specific scheduled report output.
Signature
JobOutputsList getScheduledReportOutputInfo(String jobInstanceID, String userID, String password);
Use the getScheduledReportOutputInfo() method to return information about a specific scheduled report output based on its jobInstanceID and the bipSessionToken of a given user.
For more information about in-session methods, see Section 1.2, "About In-Session Methods."
Signature
JobOutputsList getScheduledReportOutputInfoInSession(String jobInstanceID, String bipTokenSession);
Table 3-26 Parameters for getScheduledReportOutputInfoInSession() Method
Parameter | Description |
---|---|
String jobInstanceID |
The ID of the job for which to return job information. |
String bipSessionToken |
The proprietary token string generated for the user by the BI Publisher server. With the bipSessionToken string, the user no longer needs to provide user credentials. The BI Publisher server can validate this token string and restore the BI Publisher server session to perform needed operation. |
Use the getXMLData() method to return, in XML format, the data document generated by a BI Publisher scheduled job. You can use the JobOutputID returned from the scheduleReport() method to retrieve the generated XML document.
Note, the getXMLData() method returns the byte[] of a report document, while the downloadXMLData() Method saves the XML data on the BI Publisher server as a local file. The latter method returns the file ID, enabling the user to download the XML-based document later through the Delivery Service. This is for performance concerns in cases where a report document size is quite large.
Signature
byte[] getXMLData(String JobInstanceID, String userID, String password);
Table 3-27 Parameters for getXMLData() Method
Parameter | Description |
---|---|
String JobInstanceID |
The ID assigned to the instance of the job that generated the output. The JobInstanceID is a string of integers. |
String userID |
Specifies the BI Publisher user name. |
String password |
Specifies the password for the user name. |
Returns the byte[] of XML data based on the jobInstanceID and bipSessionToken of a given user.
For more information about in-session methods, see Section 1.2, "About In-Session Methods."
Signature
byte[] getXMLDataInSession(String jobInstanceID, String bipSessionToken);
Table 3-28 Parameters for getXMLDataInSession() Method
Parameter | Description |
---|---|
String jobInstanceID |
The ID assigned to the job instance. The jobInstanceID is a string of integers. |
String bipSessionToken |
The proprietary token string generated for the user by the BI Publisher server. With the bipSessionToken string, the user no longer needs to provide user credentials. The BI Publisher server can validate this token string and restore the BI Publisher server session to perform needed operation. |
Use the purgeHistory() method to perform a "hard" delete of the historical information about a report job. That is, to permanently purge the information from the database.
You must precede the purgeJobHistory() method with the deleteJobHistory() method, otherwise the following SOAP fault is thrown:
purgeJobHistory failed due to job is not deleted. You have to delete JobHistory first prior to purge.
Signature
boolean purgeJobHistory(String instanceJobID, String userID, String password);
Table 3-29 Parameters for purgeJobHistory() Method
Parameter | Description |
---|---|
String instanceJobID |
The ID assigned to the instance of the job that generated the output. The instanceJobID is a string of integers. |
String userID |
Specifies the BI Publisher user name. |
String password |
Specifies the password for the user name. |
Permanently purges the job history from the database for the given instanceJobID and bipSessionToken of the given user. This action must be preceded by a deleteJobHistoryInSession.
For more information about in-session methods, see Section 1.2, "About In-Session Methods."
Signature
boolean purgeJobHistoryInSession(String instanceJobID, String bipSessionToken);
Table 3-30 Parameters for purgeJobHistoryInSession() Method
Parameter | Description |
---|---|
String instanceJobID |
The ID assigned to the job instance. The instanceJobID is a string of integers. |
String bipSessionToken |
The proprietary token string generated for the user by the BI Publisher server. With the bipSessionToken string, the user no longer needs to provide user credentials. The BI Publisher server can validate this token string and restore the BI Publisher server session to perform needed operation. |
Use the resendScheduledReport() method to resend a previously-defined scheduled report. The resend action is respective to the outputJobID. There's no need to define any delivery channels options, as the previously-defined delivery parameters are used to perform the resend action.
Signature
boolean resendScheduledReport(String outputJobID, String userID, String password);
Resends a previously-defined scheduled report based on its associated outputJobID and the bipSessionToken of a given user.
For more information about in-session methods, see Section 1.2, "About In-Session Methods."
Signature
boolean resendScheduledReportInSession(String outputJobID, String bipSessionToken);
Table 3-32 Parameters for resendScheduledReportInSession() Method
Parameter | Description |
---|---|
String outputJobID |
The ID of the scheduled job to resend. |
String bipSessionToken |
The proprietary token string generated for the user by the BI Publisher server. With the bipSessionToken string, the user no longer needs to provide user credentials. The BI Publisher server can validate this token string and restore the BI Publisher server session to perform needed operation. |
Use the resumeSchedule() method to resume a schedule job that has been suspended.
Signature
boolean resumeSchedule(String jobInstanceID, String userID, String password);
Table 3-33 Parameters for resumeSchedule() Method
Parameter | Description |
---|---|
String jobInstanceID |
The ID assigned to the instance of the job to be resumed. The jobInstanceID is a string of integers. |
String userID |
Specifies the BI Publisher user name. |
String password |
Specifies the password for the user name. |
Resumes a scheduled job that was previously suspended based on its jobInstanceID and the bipSessionToken of a given user.
For more information about in-session methods, see Section 1.2, "About In-Session Methods."
Signature
boolean resumeScheduleInSession(String outputJobID, String bipSessionToken);
Table 3-34 Parameters for resumeScheduleInSession() Method
Parameter | Description |
---|---|
String jobInstanceID |
The ID assigned to the instance of the job to be resumed. The jobInstanceID is a string of integers. |
String bipSessionToken |
The proprietary token string generated for the user by the BI Publisher server. With the bipSessionToken string, the user no longer needs to provide user credentials. The BI Publisher server can validate this token string and restore the BI Publisher server session to perform needed operation. |
Use the scheduleReport() method to schedule the reports that are in the BI Publisher catalog. You can submit and run the reports immediately or create a job to schedule the reports to run. When you schedule reports you can also deliver reports to any of delivery types that are set up in your BI Publisher Enterprise Server instance. The method will return a jobID of the scheduled job.
Signature
String scheduleReport(ScheduleRequest scheduleRequest, String userID, String password);
Table 3-35 Parameters for scheduleReport() Method
Parameter | Description |
---|---|
ScheduleRequest scheduleRequest |
Specifies a ScheduleRequest object for the report that you want to run. See Section 2.3.48, "ScheduleRequest." |
String userID |
Specifies the BI Publisher user name. |
String password |
Specifies the password for the user name. |
Schedules a report based on the schedule request, delivery channel, and bipSessionToken of a given user.
For more information about in-session methods, see Section 1.2, "About In-Session Methods."
Signature
String scheduleReportInSession(ScheduleRequest scheduleRequest, DeliveryChannel deliveryChannel, String bipSessionToken);
Table 3-36 Parameters for scheduleReportInSession() Method
Parameter | Description |
---|---|
ScheduleRequest scheduleRequest |
Specifies a ScheduleRequest object for the report that you want to run. See Section 2.3.48, "ScheduleRequest.". |
DeliveryChannel deliveryChannel |
Specifies the delivery channels through which the report will be delivered. See Section 2.3.20, "DeliveryChannels." |
String bipSessionToken |
The proprietary token string generated for the user by the BI Publisher server. With the bipSessionToken string, the user no longer needs to provide user credentials. The BI Publisher server can validate this token string and restore the BI Publisher server session to perform needed operation. |
Use the suspendSchedule() method to suspend a schedule job.
Signature
boolean suspendschedule(String jobInstanceID, String userID, String password);
Table 3-37 Parameters for suspendSchedule() Method
Parameter | Description |
---|---|
String jobInstanceID |
The ID assigned to the instance of the job to be suspended. The jobInstanceID is a string of integers. |
String userID |
Specifies the BI Publisher user name. |
String password |
Specifies the password for the user name. |
Suspends a scheduled report based on its associated jobInstanceID and the bipSessionToken of a given user.
For more information about in-session methods, see Section 1.2, "About In-Session Methods."
Signature
boolean suspendScheduleInSession(String jobInstanceID, String bipSessionToken);
Table 3-38 Parameters for suspendScheduleInSession() Method
Parameter | Description |
---|---|
String jobInstanceID |
The ID assigned to the instance of the job to be suspended. The jobInstanceID is a string of integers. |
String bipSessionToken |
The proprietary token string generated for the user by the BI Publisher server. With the bipSessionToken string, the user no longer needs to provide user credentials. The BI Publisher server can validate this token string and restore the BI Publisher server session to perform needed operation. |