This chapter describes the services and methods used by the Oracle Business Intelligence Session-Based Web Services.
This document uses JavaScript-like syntax to describe structures. The exact syntax and implementation depends on the SOAP code generation tool and the target language used by your application development environment.
This chapter includes the following sections:
Use this service to initiate export of analysis reports and retrieve exported files in PDF, MHTML, Excel 2007 and CSV formats.
Table 3-1 shows the supported methods.
Table 3-1 AnalysisExportViews Methods
| Method Name | Description |
|---|---|
|
Initiates and retrieves exported files of analysis. |
|
|
Retrieves exported files |
Use this method to initiate and retrieve exported files of analysis in the following formats - PDF, MHTML, Excel 2007, CSV.
initiateAnalysisExport(ReportRef reportRef, AnalysisExportOutputFormat outputFormat, AnalysisExportExecutionOptions executionOptions, ReportParams reportParams, String reportViewName, String sessionID);
| Arguments | Description |
|---|---|
| ReportRef reportRef | Specifies the path to the analysis definition, supplied in the ReportRef common structure. |
| AnalysisExportOutputFormat outputFormat | Specifies one of the following output formats that you can select:
|
| AnalysisExportExecutionOptions executionOptions | Specifies the execution options in the AnalysisExportExecutionOptions structure. For more information, see |
| ReportParams reportParams | Specifies the filters or variables to apply to the analysis before execution, supplied in the ReportParams common structure. |
| String reportViewName | Specifies the view to export. If this parameter is null, the analysis default view is used. The view name should match the one used to identify the view in the analysis XML definition. |
| String sessionID | Specifies the session ID. |
Returns an output as defined in the AnalysisExportResult structure. For information on the AnalysisExportResult structure, see Section 2.7, "AnalysisExportResult Structure."
Use this method to retrieve exported files in PDF, MHTML, Excel 2007, or CSV formats.
completeAnalysisExport(String queryID, String sessionID);
| Arguments | Description |
|---|---|
| String queryID | Specifies query ID returned by the initiateAnalysisExport method. For more information, see Section 3.1.1, "initiateAnalysisExport () Method." |
| String SessionID | Specifies the unique session ID. |
Returns an output as defined in the AnalysisExportResult structure. For information on the AnalysisExportResult structure, see Section 2.7, "AnalysisExportResult Structure."
Use this service to evaluate Oracle BI EE conditions programatically. This service also allows users to obtain the customizable filters available in a condition.
Table 3-2 shows the supported methods.
Table 3-2 ConditionService Methods
| Method Name | Description |
|---|---|
|
Evaluates a condition saved to the catalog. |
|
|
Evaluate a condition supplied as a parameter. |
|
|
Section 3.2.3, "getConditionCustomizableReportElements() Method" |
Obtains the customizable filters of a condition saved to the catalog. |
Use this method to evaluate a Condition that is stored in the catalog. This method returns an XML string containing the result of the condition (true or false).
boolean evaluateCondition(String path, String[] reportCustomizationParameters, String sessionID);
| Arguments | Description |
|---|---|
| String path | Specifies the full path and name of the Condition in the catalog. For example, /users/jchan/Conditions/IsRegionUnderBudget. |
| String [] reportCustomizationParameters | Specifies the customization parameters XML, which is only used if the Condition has customizable filters. This XML is validated against the customization schema available in orahome/bifoundation/web/schemas/analysis_customization.xsd. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to evaluate a condition defined outside of Oracle BI EE Presentation Services. The Condition XML is supplied in the conditionXML parameter. This method returns an XML string with the result of the condition evaluation, true or false.
boolean evaluateInlineCondition(String conditionXML, String[] reportCustomizationParameters, String sessionID);
| Arguments | Description |
|---|---|
| String conditionXML | Specifies the Condition XML. This XML is validated against the condition schema available in orahome/bifoundation/web/schemas/condition.xsd. |
| String[] ListreportCustomizationParameters | Specifies the customization parameters XML, which is only used if the Condition has customizable filters. This XML is validated against the customization schema available in orahome/bifoundation/web/schemas/analysis_customization.xsd. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to determine the customizable filters available in a condition that is stored in the catalog. This method returns an XML string containing the definition of the customizable filters available in the condition. The XML is in the format defined in the customization schema available in orahome/bifoundation/web/schemas/analysis_customization.xsd.
String[] getConditionCustomizableReportElements(String path, String sessionID);
| Arguments | Description |
|---|---|
| String path | Specifies the full path and name of the condition in the catalog. For example, /users/jchan/Conditions/IsRegionUnderBudget. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this service to embed Oracle BI EE HTML results in third-party dynamic web pages, such as Active Server Pages (ASP) or JavaServer Pages (JSP), and portal frameworks. The embed process merges Oracle BI EE web services content with the content of third-party web pages.
Table 3-3 shows the supported methods.
Table 3-3 HtmlViewService Methods
| Method Name | Description |
|---|---|
|
Adds results to an HTML page. |
|
|
Destroys a server page object and all data associated with it. |
|
|
Retrieves HTML to include in the <BODY> section. |
|
|
Retrieves HTML to include in the <HEAD> section. |
|
|
Retrieves HTML for a page that contains only one analysis. |
|
|
Retrieves HTML to display a particular set of results. |
|
|
Specifies a bridge URL to receive communications. Can be useful when the Oracle Business Intelligence web services server and the Presentation Services that the user is accessing reside on different machines or when you want to modify the results in your application development environment. |
|
|
Creates a new page object and returns its ID. |
The methods in the HTMLViewService service extract fragments of HTML code that can be inserted in third-party web pages. Table 3-4 describes the HTML code excerpts and desired page locations.
Table 3-4 HTML Code Fragments and Page Locations for the HtmlViewService Service
| HTML Code Fragment | Desired Page Location |
|---|---|
|
Header |
Should be inserted in the <HEAD> section of an HTML page. The code contains links to common JavaScript files and style sheets. |
|
Report Objects |
Can be inserted anywhere in the <BODY> section. |
|
Common Body |
Should be inserted in the <BODY> tag after all analysis links. The code contains hidden HTML elements that are used to implement drilldown links. |
For each returned analysis object, the HTML code fragment contains a callback link that is followed automatically when the web page is loaded by the browser. The code fragment does not contain the full user interface definition of the analysis. While the analysis is being constructed by Oracle BI EE Presentation Services, the interface displays the Oracle BI EE web services "Searching..." image embedded on the third-party web page.
For smooth analysis transitioning, Oracle BI EE Presentation Services tracks the Oracle Business Intelligence analyses that have been added to third-party web pages by maintaining information in an internal logical page object during the construction of the third-party web page. The HtmlViewService service methods explicitly refer to the internal logical page by its ID.
To embed an analysis with active drilldown links, the HtmlViewService service allows the web browser to issue callback requests from embedded analyses to the Oracle BI EE Presentation Services server. Although it is possible to route requests directly to the Oracle BI EE Presentation Services server, in many cases it is preferable to route requests through the Oracle BI EE instance that originally serviced the third-party page. Also, in situations where Oracle BI EE Presentation Services and the third-party web server do not belong to the same Domain Name Service (DNS) domain, users may get JavaScript errors related to browser security constraints for cross-domain scripting.
To avoid these issues, use the setBridge() method to modify callback URLs to point to the third-party web server. Be aware that a web component executed by the third-party web server to re-route requests to Oracle BI EE Presentation Services is not provided. This function would need to be fulfilled by the third-party application. For more information about the setBridge() method, see Section 3.3.8, "setBridge() Method".
Use this method to add results to an HTML page.
void addReportToPage(String pageID, String reportID, ReportRef report, String reportViewName, ReportParams reportParams, ReportHTMLOptions options, String sessionID);
| Arguments | Description |
|---|---|
| String pageID | Specifies a character string page ID returned by the startPage() method. For information about the startPage () method, see Section 3.3.9, "startPage() Method". |
| String reportID | Specifies a character string that identifies the analysis containing the results to add to the page. It should be used to reference this analysis in subsequent method invocations; for example, corresponding user interface elements generated by the Oracle Business Intelligence Presentation Services server would reference the same ID. |
| ReportRef report | Specifies the analysis definition, supplied in the ReportRef structure. |
| String reportViewName | Specifies the view to display. If this parameter is null, the analysis' default view is used. The view name should match the one used to identify the view in the analysis XML definition. |
| ReportParams reportParams | Optional. Specifies the filters or variables to apply to the analysis before execution, supplied in the ReportParams common structure.
For more information, see Section 3, "Description of Services and Methods in Oracle BI EE Web Services". |
| ReportHTMLOptions options | Optional. Specifies the display options to apply to the analysis after execution, supplied in the ReportHTMLOptions structure. For more information, see Section 2.41, "QueryResults Structure". |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to destroy the Oracle BI EE Presentation Services server page object and all data associated with it.
void endpage(String pageID, String sessionID);
| Arguments | Description |
|---|---|
| String pageID | Specifies the ID of the page object, which is returned by the startPage() method (for more information, see Section 3.3.9, "startPage() Method"). |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to retrieve HTML to include in the <BODY> section.
String getCommonBodyHTML(String pageID, String sessionID);
| Arguments | Description |
|---|---|
| String pageID | Specifies the ID of the page object, which is returned by the startPage() method (for more information, see Section 3.3.9, "startPage() Method"). |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to retrieve HTML to include in the <HEAD> section.
String getHeadersHTML(String pageID, String sessionID);
| Arguments | Description |
|---|---|
| String pageID | Specifies the ID of the page object, which is returned by the startPage() method (for more information, see Section 3.3.9, "startPage() Method"). |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to retrieve the HTML for a page that contains only one analysis. A page that contains only one analysis does not have <BODY> and <HEAD> sections.
String getHtmlForPageWithOneReport(String reportID, ReportRef report, String reportViewName, ReportParams reportParams, ReportHTMLOptions reportOptions, StartPageParams pageParams, String sessionID);
| Arguments | Description |
|---|---|
| String pageReportID | Specifies the analysis ID returned by the getHtmlForPageWithOneReport() method.
For information about the addReportToPage method, see Section 3.3.2, "addReportToPage() Method". |
| ReportRef report | Specifies the analysis definition, supplied in the ReportRef structure. |
| String reportViewName | Specifies the view to display. If this parameter is null, the analysis' default view is used. The view name should match the one used to identify the view in the analysis XML definition. |
| ReportParams reportParams | Optional. Specifies the filters or variables to apply to the analysis before execution, supplied in the ReportParams common structure.
For more information, see Section 3, "Description of Services and Methods in Oracle BI EE Web Services". |
| ReportHTMLOptions reportOptions | Optional. Specifies the display options to apply to the analysis after execution, supplied in the ReportHTMLOptions structure. For more information, see Section 2.41, "QueryResults Structure". |
| StartPageParams pageParams | Specifies the options to use when starting the page, supplied in the StartPageParams structure. For information about the StartPageParams structure, see Section 2.58, "StartPageParams Structure". |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to retrieve an HTML excerpt to display the results for a particular analysis. Before invoking this method, use the addReportToPage method to add the results to an HTML page.
String getHTMLForReport(String pageID, String pageReportID, String sessionID);
| Arguments | Description |
|---|---|
| String pageID | Specifies the ID of the page object, which is returned by the startPage() method (for more information, see Section 3.3.9, "startPage() Method"). |
| String pageReportID | Specifies the analysis ID returned by the addReportToPage() method.
For information about the addReportToPage method, see Section 3.3.2, "addReportToPage() Method". |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to specify a bridge URL to receive communications. Specifying a bridge URL can be useful when the Oracle BI EE web services server and the user's web server reside on different machines, or when you want to modify the results in your application development environment.
After the setBridge() method is called, all requests from the client browser to the Oracle BI EE Presentation Services server are sent to the bridge URL, which then forwards requests to the Oracle BI EE Presentation Services server.
setBridge(String bridge, String sessionID);
| Arguments | Description |
|---|---|
| String bridge | Specifies the bridge URL. For example,
http://myserver/myapplication/sawbridge |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
You must make sure that the client browser provides a handler to the bridge URL in the form of a Java servlet, an Active Server Pages (ASP) page, a Common Gateway Interface (CGI), an Internet Server application programming interface (ISAPI), or an equivalent application.
You must also perform the following tasks:
Decode the path of the requested Oracle BI EE web services resource in the RedirectURL argument of the request character string. For information about the RedirectURL argument, see Section 3.3.8.3, "How Callback URLs Are Replaced".
Forward all other request arguments, together with all headers and the request body, to the bridge URL.
Copy the response from the Oracle BI EE Presentation Services server to the response stream.
The new callback URL is based on the bridge URL, with the addition of a RedirectURL argument. The value of the RedirectURL argument should be the original value of the URL, encoded using standard URL encoding rules.
Internally, Oracle BI EE web services usually uses relative URLs for callback links. For example, if the original callback link is saw.dll?Go and the bridge URL is
http://myserver/myapplication/sawbridge
then the new callback URL is
http://myserver/myapplication/sawbridge?RedirectURL=saw.dll%3fGo
Use this method to create a page object and returns its ID.
String startPage(StartPageParams options, String sessionID);
| Arguments | Description |
|---|---|
| StartPageParams options | Specifies the options to use when starting the page, supplied in the StartPageParams structure. For information about the StartPageParams structure, see Section 2.58, "StartPageParams Structure". |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this service to save, edit, delete, subscribe, unsubscribe, customize, and execute Oracle BI EE agents. Note that as of the Oracle Business Intelligence 11g (11.1.1) release, "iBots" have been renamed to "agents."
Table 3-5 shows the supported methods.
| Method Names | Description |
|---|---|
|
Writes a new agent into the catalog and registers it with Oracle BI Scheduler. |
|
|
Deletes an agent from the catalog and deregisters it from the Oracle BI Scheduler. |
|
|
Executes an agent saved in the catalog. |
|
|
Moves an agent from one catalog folder to another. |
|
|
Sends a message to an Oracle BI EE user, group, or user and group. |
|
|
Subscribes to a published agent. Also customizes your subscription. |
|
|
Unsubscribes from an agent. |
Use this method to write a new agent to the catalog and to register it with Oracle BI Scheduler. Note that this method is different from the WebCatalogService service's "writeObjects() Method", which only writes to the catalog.
int writeIBot (CatalogObject obj, String path, boolean resolveLinks, boolean allowOverwrite, String sessionID);
| Arguments | Description |
|---|---|
| CatalogObject obj | Specifies the object to be written to the catalog. The object's XML is validated against analysis_ibot.xsd, which is located in orahome/bifoundation/web/schemas directory. |
| String path | Specifies the full path and name of the agent in the catalog. For example, /users/jchan/iBots/BrandDollars. |
| boolean resolveLinks | If set to TRUE and the path in the catalog refers to a link, then the object is written to the location pointed to by the link. |
| boolean allowOverwrite | Specifies whether to overwrite an existing object. Set to TRUE to overwrite any object already present in the location specified by "path." |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to delete a saved agent. Deleting an agent not only removes it (the object) from the catalog, but it also deregisters the agent from the Oracle BI Scheduler. Note that this method is different from the "WebCatalogService Service" "deleteitem" method because the "deleteitem" method does not deregister the agent from the Oracle BI Scheduler.
void deleteIBot (String path, String sessionID);
| Arguments | Description |
|---|---|
| String path | Specifies the full path and name of the agent in the catalog. For example, /users/jchan/iBots/BrandDollars. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to execute an agent that is stored in the catalog. Note that this method does not change the agent's original schedule.
void executeIBotNow(String path, String sessionID);
| Arguments | Description |
|---|---|
| String path | Specifies the full path and name of the agent in the catalog. For example, /users/jchan/iBots/BrandDollars. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to move an agent from one catalog folder to another. Note that this method is different from the "WebCatalogService Service" "moveItem" method because the "moveItem" method moves the catalog object and informs the Oracle BI Scheduler that the object was moved.
void moveIBot(String fromPath, String toPath, boolean resolveLinks, boolean allowOverwrite, String sessionID);
| Arguments | Description |
|---|---|
| String fromPath | Specifies the full catalog path of the agent to be moved. |
| String toPath | Specifies the full catalog path where the agent is moved to. |
| boolean resolveLinks | Specifies if you want to move the child objects. If this argument is set to TRUE and the path specified in the "fromPath" argument is a link, then the child object pointed to by that link is moved. |
| boolean allowOverwrite | Specifies if you want to overwrite an existing object. If this argument is set to TRUE and another catalog object existed in the path specified by "toPath", it is overwritten. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to send a message to a Oracle BI EE user, group, or user and group. The message is delivered according to the corresponding recipient's delivery profile, which was set up in the "My Account dialog" in Oracle BI Presentation Services.
String sendMessage(String[] recipient, String[] group, String subject, String body, String priority, String sessionID);
| Arguments | Description |
|---|---|
| String[] recipient | Specifies the GUID of the Oracle BI EE user to whom you want to send the message. You can include more than one user in this argument. |
| String[] group | Specifies the GUID of the Oracle BI EE group to whom you want to send the message. You can include more than one group in this argument. |
| String subject | Specifies the subject line of the message. |
| String body | Specifies the text to be included in the body of the message. |
| String priority | Specifies the message's priority. You can specify "High," "Normal," or "Low." |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to subscribe to a published agent. If the agent allows customization, then you can also specify the customization XML.
void subscribe(String path, String customizationXml, String sessionID);
| Arguments | Description |
|---|---|
| String path | Specifies the full path and name of the agent in the catalog. For example, /users/jchan/iBots/BrandDollars. |
| String customizationXml | Specifies the customization XML (only if the agent allows customizations). This XML is validated against the customization schema available in orahome/bifoundation/web/schemas/analysis_customization. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to unsubscribe from an agent. This method also deletes any user customizations.
void unsubscribe(String path, String sessionID);
| Arguments | Description |
|---|---|
| String path | Specifies the full path and name of the agent in the catalog. For example, /users/jchan/iBots/BrandDollars. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this service to execute marketing segmentation and list generation functionality.
Table 3-6 shows the supported methods.
Table 3-6 JobManagementService Methods
| Method Name | Description |
|---|---|
|
Cancels a running marketing job. |
|
|
Deletes a saved result set. |
|
|
Generates the count numbers for a segment or segment tree. |
|
|
Gets status and detailed information about a marketing job. |
|
|
Returns prompted columns for a segment or segment tree. |
|
|
Caches a segment or segment tree for list export. |
|
|
Purges the whole cache, entries for a segment, or entries for the segment tree. |
|
|
Saves a list of members based on the most recent updated counts. |
|
|
Generates a list for list export, segment campaign load, or segment tree campaign load. |
Use this method to cancel a running marketing job.
JobInfo cancelJob(BigInteger jobID, String sessionID);
| Arguments | Description |
|---|---|
| BiInteger jobID | Specifies the marketing job ID. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to delete one or more saved results sets of target-level objects identified by a list of GUID values belonging to the specified segment.
JobInfo deleteResultSet(String targetLevel, ArrayOfGUIDs guiDs, String segmentPath, String sessionID);
| Arguments | Description |
|---|---|
| String targetLevel | Specifies the target level of the saved results set. |
| ArrayOfGUIDs guiDs | Specified a list of GUIDs representing the saved result set. For information on the ArrayOfGUIDs structure, see Table 2-8, "ArrayofGUIDS Structure Fields". |
| String segmentPath | Specifies the path to the segment. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to generate the count numbers for either a segment or a segment tree.
JobInfo getCounts(String segmentPath, String treePath, SegmentationOptions segmentationOptions, String sessionID);
| Arguments | Description |
|---|---|
| String segmentPath | Specifies the path to the segment. Used when getCounts is performed on a segment. |
| String treePath | Specifies the path to the segment tree. Used when getCounts is performed on a segment tree. |
| Segmentation Options |
Specifies the segment and segment tree override options supplied in the SegmentationOptions structure. These options are used instead of the segment or segment tree defaults as specified in the Oracle Marketing Analytics user interface. For more information about the SegmentationOptions structure, see Section 2.56, "SegmentationOptions Structure". |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to get the status and detailed job information about a marketing job.
JobInfo getJobInfo(BigInteger jobID, String sessionID);
| Arguments | Description |
|---|---|
| BigInteger jobID | Specifies the marketing job ID. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to return prompted columns for a segment or segment tree.
PromptedColumnInfo getPromptedColumns(String segmentPath, String treePath, String sessionID);
| Arguments | Description |
|---|---|
| String segmentPath | Specifies the path to the segment. Used when getPromptedColumns is performed on a segment. |
| String treePath | Specifies the path to the segment tree. Used when gePromptedColumns is performed on a segment tree. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to cache a segment or segment tree for list export.
JobInfo prepareCache(String segmentPath, String treePath, Boolean refresh, String sessionID);
| Arguments | Description |
|---|---|
| String segmentPath | Specifies the path to the segment. Used when prepareCache is performed on a segment. |
| String treePath | Specifies the path to the segment tree. Used when prepareCache is performed on a segment tree. |
| Boolean refresh | If set to TRUE, then the system populates cache entries on cache hits and populates cache entries on cache misses. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to purge the whole cache, purge entries for a segment from the cache, or purge entries for the segment tree from the cache.
JobInfo purgeCache(String segmentPath, String treePath, Boolean ignoreCacheRef, String sessionID);
| Arguments | Description |
|---|---|
| String segmentPath | Specifies the path to the segment.Used when purgeCache is performed on a segment. |
| String treePath | Specifies the path to the segment tree. Used when purgeCache is performed on a segment tree. |
| Boolean ignoreCacheRef | If set to TRUE, the system purges the cache entries that are currently used and referenced by segments, segment trees, expired cache entries, and non-existent cache-entries. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to save a list of members that qualify for the segment or segment tree based on the most recent updated counts. The system extracts and saves the members to the segment path that you specify.
JobInfo saveResultSet(String segmentPath, TreeNodePath treeNodePath, String savedSegmentPath, SegmentationOptions segmentationOptions, String srCustomLabel, Boolean appendStaticSegment, String sessionID);
| Arguments | Description |
|---|---|
| String segmentPath | Specifies the path to the segment. |
| TreeNodePath treeNodePath | Specifies the segment tree path and branch ID number. |
| String savedSegmentPath | Specifies the path and name of the new segment where the system extracts and saves the resulting members. |
| Segmentation Options segmentation Options |
Specifies the segment and segment tree override options supplied in the SegmentationOptions structure. These options are used instead of the segment or segment tree defaults as specified in the Oracle Marketing Analytics user interface. For more information about the SegmentationOptions structure, see Section 2.56, "SegmentationOptions Structure". |
| String srCustomLabel | Specifies the custom label for creating a static segment. |
| Boolean appendStaticSegment | Specifies a flag to create a static segment entry under the same saved segment path. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to generate lists for list export, segment campaign load, or segment tree campaign load.
JobInfo writeListFiles(ReportRef report, ReportParams reportParams, String segmentPath, TreeNodePath treeNodePath, SegmentationOptions segmentationOptions, String filesystem, BigInteger timeout, String sessionID);
| Arguments | Description |
|---|---|
| ReportRef report | Specifies the analysis reference definition supplied in the ReportRef structure. For more information about the ReportRef structure, see Section 2.50, "ReportRef Structure". |
| ReportParams reportParams | Specifies the filters or variables to apply to the analysis before execution. This information is supplied in the ReportParams common structure. For more information about the ReportParams structure, see Section 2.47, "ReportParams Structure". |
| String segmentPath | Specifies the path to the segment. |
| TreeNodePath treeNodePath | Specifies the segment tree path and branch ID. |
| SegmentationOptions segmentationOptions | Specifies the segment and segment tree override options supplied in the SegmentationOptions structure. These options are used instead of the segment or segment tree defaults as specified in the Oracle Marketing Analytics user interface. For more information about the SegmentationOptions structure, see Section 2.56, "SegmentationOptions Structure". |
| String filesystem | Specifies the path to the shared directory that contains list files. |
| BigInteger timeout | Specifies the time out value. This is always set to 0. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this service to provide methods for assessing KPIs. Table 3-7 shows the supported methods.
Table 3-7 KPIAssessmentService Methods
| Method Names | Description |
|---|---|
|
Requests assessments for the specified KPIs. |
|
|
Retrieves a list of values for the specified KPI's dimension. |
|
|
Generates an Oracle Business Intelligence report containing a detail report for the specified KPI. |
|
|
Returns the list of dimensions used by the KPIs in the Watchlist. |
Use this method to request assessments for the specified KPIs.
KPIResultSet executeKPI(Array KPIRequests, Array KPIColumnNames, Array Variables, Boolean UseAsyncService, Boolean Fresh, String sessionID);
| Arguments | Description |
|---|---|
| KPIRequest[] KPIRequests | Specifies KPIRequest structure objects defining the KPIs you want assessments for. For more information, see Section 2.30, "KPIRequest Structure". |
| String[] KPIColumnNames | Specifies an array of strings from the KPIColumnName enumeration. For more information, see Section 2.28, "KPIColumnName Enumeration" |
| Variable[] Variables | (Optional) Specifies an array of Variable objects that you want to apply in the query. For more information, see Section 2.64, "Variable Structure". |
| Boolean UseAsyncService | Specifies whether to use the asynchronous version of the KPI Assessment Service (true) or not (false). |
| Boolean Fresh | (Optional) Specifies whether the assessments should be freshly retrieved (true) or whether cached values suffice (false). |
| String SessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to retrieve the list of values for the specified KPI's dimension.
KPIDimensionLOVQueryResult KPIDimensionLOVQuery(Integer RowsPerFetch, String KPIPath, String DimensionID, String SessionID);
| Arguments | Description |
|---|---|
| Integer RowsPerFetch | Specifies the maximum number of values you want to retrieve. |
| String KPIPath | Specifies the catalog path to the KPI you are interested in. |
| String DimensionID | Specifies the ID of the dimension you are interested in. |
| String SessionID | Specifies the SessionID that you want to use in the SOAP request.
If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to call the KPI Engine's generateDrillTo web service method which is responsible for generating a Oracle Business Intelligence report containing a detail report for the specified KPI.
DrillToReportURLResult generateDrillTo(Object KpiRequest, String ReportPath, Array Variables, String sessionID);
| Arguments | Description |
|---|---|
| Object KPIRequest | Specifies the KPIRequest structure objects containing the pinnings. For more information, see Section 2.30, "KPIRequest Structure". |
| String ReportPath | Specifies the Presentation Services catalog path where the generated report should be saved. |
| Variable[] Variables | Specifies an array of Variable objects that you want to apply in the query. For more information, see Section 2.64, "Variable Structure". |
| String sessionID | Specifies the SAW Session ID. This parameter can usually be omitted as the session ID is stored in a cookie. |
Use this method to retrieve the superset of dimensions used by the KPIs in the specified KPI Watchlist.
KPIWatchlistDimensions KPIWatchlistDimensions(String WatchlistPath, String WatchListXML, Boolean GetFresh, Session sessionID);
| Arguments | Description |
|---|---|
| String WatchlistPath | Specifies the catalog path to the KPI Watchlist you are interested in. |
| String WatchListXML | Specifies the KPI Watchlist catalog XML containing unsaved metadata. |
| Session sessionID | (Optional) Specifies the SAW Session ID. This parameter can usually be omitted as the session ID is stored in a cookie. |
Use this service to retrieve descriptions of Oracle Business Intelligence Presentation Services schema objects, such as columns, tables, and subject areas.
Table 3-8 shows the supported methods.
Table 3-8 MetadataService Methods
| Method Names | Description |
|---|---|
|
Clears the query cache. |
|
|
Retrieves column information for a specified column in a specified subject area and table. |
|
|
Retrieves subject area information for a specified subject area. |
|
|
Retrieves subject area information for a specified subject area in the specified sort order. |
|
|
Retrieves table information for a specified table in a specified subject area. |
|
|
Retrieves table information for a specified table in a specified subject area in the specified sort order (of their names). |
|
|
Retrieves the list of subject areas available. |
|
|
Retrieves the list of subject areas available in the specific sort order. |
|
|
Forces changes to logging configuration to take effect without manually restarting Oracle BI Presentation Services. |
|
|
Reloads XML message files, refresh server metadata, and clear caches. |
Use this method to clear the query cache.
Use this method to retrieve column information for a specified column in a specified subject area and table.
SAColumn describeColumn(String subjectAreaName, String tableName, String columnName, String sessionID);
| Arguments | Description |
|---|---|
| String subjectAreaName | Specifies the subject area to be queried. |
| String tableName | Specifies the table to be queried. |
| String columnName | Specifies the name of the column to be queried. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Returns an SAColumn Object. For information on the SAColumn structure, see Section 2.51, "SAColumn Structure".
Use this method to retrieve subject area information about the specified subject area.
SASubjectArea describeSubjectArea (String subjectAreaName, SASubjectAreaDetails detailsLevel, String sessionID);
| Arguments | Description |
|---|---|
| String subjectAreaName | Specifies the subject area to be queried. |
| SASubjectAreaDetails detailsLevel | Specifies the information to be retrieved about the subject area. For information on the SASubjectAreaDetails structure, see Section 3.7.3.2, "SASubjectAreaDetails Values". |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to specify what information should be retrieved about the subject area. Table 3-9 lists the available values.
Returns an SASubjectArea Object (for more information, see Section 2.52, "SASubjectArea Structure").
Depending on the value of the detailsLevel parameter, the returned object contains the information specified in Table 3-10.
Table 3-10 detailsLevel Values
| Value of detailsLevel | Description |
|---|---|
|
IncludeTables |
Specifies that the tables field is not null and contains the collection of tables for this subject area. Each table object has the columns field set to null. |
|
InludeTablesAndColumns |
Specifies that the tables field is not null and contains the collection of tables for this subject area. For each table object the columns field contains the corresponding collection of columns. |
|
Minimum |
Specifies that the table list is not available. The tables field in the resulting subject area object is null. |
Use this method to retrieve subject area information about the specified subject area in the specified sort order.
SASubjectArea describeSubjectAreaWithSort (String subjectAreaName, SASubjectAreaDetails detailsLevel, String sortOrder, String sortOrderCaseSensitive, String sessionID);
| Arguments | Description |
|---|---|
| String subjectAreaName | Specifies the subject area to be queried. |
| SASubjectAreaDetails detailsLevel | Specifies the information to be retrieved about the subject area. For information on the SASubjectAreaDetails structure, see Section 3.7.3.2, "SASubjectAreaDetails Values". |
| String sortOrder | Specifies specifies which sort order you want the results returned in. Values can be 'asc' or 'desc'. 'asc' returns values in ascending order of the current language of the user (for example, in English, A to Z), and conversely 'desc' returns in the reverse order (for example, in English - from Z to A). |
| String sortOrderCaseSensitive | Specifies if the case of the values need to be taken into consideration during sort. Values can be 'caseSensitive' or 'caseInsensitive'. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Returns an SASubjectArea Object (for more information, see Section 2.52, "SASubjectArea Structure") with tables returned in the specified sort order.
Use this method to retrieve table information for a specified table in a specified subject area.
SATable describeTable (String subjectAreaName, String tableName, SATableDetails detailsLevel, String sessionID);
| Arguments | Description |
|---|---|
| String subjectAreaName | Specifies the subject area to be queried. |
| String tableName | Specifies the table to be queried. |
| SATableDetails detailsLevel | Specifies the information to retrieve about the table. For information on the SATableDetails structure, see Section 3.7.5.2, "SATablesDetails Values". |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Used to specify the information to retrieve about the table. Table 3-11 lists the available values.
Returns an SATable Object. For information on the SATable structure, see Section 2.53, "SATable Structure".
Use this method to retrieve table information for a specified table in the specified sort order (of their names).
SATable describeTable (String subjectAreaName, String tableName, SATableDetails detailsLevel, String sortOrder, String sortOrderCaseSensitive, String sessionID);
| Arguments | Description |
|---|---|
| String subjectAreaName | Specifies the subject area to be queried. |
| String tableName | Specifies the table to be queried. |
| SATableDetails detailsLevel | Specifies the information to retrieve about the table. For information on the SATableDetails structure, see Section 3.7.5.2, "SATablesDetails Values". |
| String sortOrder | Specifies specifies which sort order you want the results returned in. Values can be 'asc' or 'desc'. 'asc' returns values in ascending order of the current language of the user (for example, in English, A to Z), and conversely 'desc' returns in the reverse order (for example, in English - from Z to A). |
| String sortOrderCaseSensitive | Specifies if the case of the values need to be taken into consideration during sort. Values can be 'caseSensitive' or 'caseInsensitive'. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Returns an SATable Object with columns in the specified sort order. For information on the SATable structure, see Section 2.53, "SATable Structure".
There is a fixed order for column types. This fixed sort order is:
Nested folders
Measures
Attributes
Hierarchies
Use this method to retrieve the list of subject areas that are available.
List[] getSubjectAreas(String sessionID);
| Arguments | Description |
|---|---|
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Returns an array of SASubjectArea objects. For information on the SASubjectArea structure, see Section 2.52, "SASubjectArea Structure".
SASubjectArea objects returned by this method do not have table information available. The tables field is null. The approach to querying at all levels is to use getSubjectAreas() to retrieve the list of subject areas and then use describeSubjectArea() to retrieve the list of tables. Next, use describeTable() to retrieve the list of columns in a specified table, and finally, use describeColumn() to retrieve information on a specified column.
Use this method to retrieve the list of subject areas that are available in the specific sort order.
List[] getSubjectAreasWithSort(String sortOrder, String sortOrderCaseSensitive, String sessionID);
| Arguments | Description |
|---|---|
| String sortOrder | Specifies specifies which sort order you want the results returned in. Values can be 'asc' or 'desc'. 'asc' returns values in ascending order of the current language of the user (for example, in English, A to Z), and conversely 'desc' returns in the reverse order (for example, in English - from Z to A). |
| String sortOrderCaseSensitive | Specifies if the case of the values need to be taken into consideration during sort. Values can be 'caseSensitive' or 'caseInsensitive'. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Returns an array of SASubjectArea objects returned in the specified sort order. For information on the SASubjectArea structure, see Section 2.52, "SASubjectArea Structure".
SASubjectArea objects returned by this method do not have table information available. The tables field is null. The approach to querying at all levels is to use getSubjectAreasWithSort() to retrieve the list of subject areas and then use describeSubjectAreaWithSort() to retrieve the list of tables. Next, use describeTableWithSort() to retrieve the list of columns in a specified table, and finally, use describeColumn() to retrieve information on a specified column.
Use this method to force changes to logging configuration to take effect without manually restarting Oracle BI Presentation Services.
Use this method to reload XML message files, refresh server metadata, and clear caches.
Use this service to merge arguments and Oracle Business Intelligence Presentation Services data to create and return the results.
Table 3-12 shows the supported methods.
Table 3-12 ReportEditingService Methods
| Method Names | Description |
|---|---|
|
Applies analysis default arguments to the analysis and returns the results. |
|
|
Applies report arguments to the analysis object and returns the results. |
|
|
Retrieves a list of criteria prompt column definitions in a given analysis and current runtime state. |
|
|
Retrieves the SQL query for a given analysis. |
|
|
Retrieves a list of criteria columns in an analysis. |
|
|
Retrieves a list of prompts, unprotected filters, and referenced presentation variables in the given report. |
Use this method to apply analysis default arguments to the analysis and returns the results.
String applyReportDefaults(ReportRef reportRefs, String sessionID);
| Arguments | Description |
|---|---|
| ReportRef object | Specifies the path to the analysis definition, supplied in the ReportRef common structure. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to apply analysis arguments to the analysis and return the results.
Object applyReportParams(ReportRef reportRef, ReportParams reportParams, boolean encodeInString, String sessionID);
| Arguments | Description |
|---|---|
| ReportRef reportRef | Specifies the path to the analysis definition, supplied in the ReportRef common structure. |
| ReportParams reportParams | Optional. Specifies the filters or variables to apply to the analysis before execution, supplied in the ReportParams common structure. For more information, see Section 3, "Description of Services and Methods in Oracle BI EE Web Services". |
| boolean encodeInString | If set to TRUE, then the returned analysis object is encoded as a character string. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to retrieve a list of criteria prompt column definitions in a given analysis and current runtime state.
getPromptElements(ReportRef promptRef, String viewState, String viewID, String portalPath, String page, NameValuePair optionalParams, String sessionID);
| Arguments | Description |
|---|---|
| ReportRef promptRef | Required. Specifies the catalog path to a saved report or a report xml document. |
| String viewState | Optional.Specifies the runtime viewState. Runtime prompt definition may be changed based on other prompts setting view viewState. |
| String viewID | Optional: Specifies the view ID |
| String portalPath | Optional: Specifies the dashboard catalog path where the report resides. |
| String page | Optional: Specifies the dashboard page name where the report resides. |
| NameValuePair optionalParams | Optional: Specifies the name of additional parameters which are usually used for debugging purposes. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to retrieve the logical SQL query for a given analysis.
String generateReportSQL(ReportRef reportRef, ReportParams reportParams, String sessionID);
| Arguments | Description |
|---|---|
| ReportRef reportRef | Specifies the path to the analysis definition supplied in the ReportRef common structure. |
| ReportParams reportParams | Optional. Specifies the path to the filters or variables to apply to the analysis before execution, supplied in the ReportParams common structure. For more information, see Section 3, "Description of Services and Methods in Oracle BI EE Web Services". |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to retrieve a list of criteria columns in a given analysis.
ReportColumn[] getReportElements(String reportPath, String sessionID);
| Arguments | Description |
|---|---|
| ReportRef reportRef | Specifies the path to the analysis definition supplied in the ReportRef common structure. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
ReportColumn[] - array of columns in the report. See Section 2.48, "ReportHierarchicalColumn" and Section 2.49, "ReportRegularColumn."
Use this method to retrieve a list of all report prompts, unprotected filters, and referenced presentation variables in the given report.
String getReportElements(String reportPath, String sessionID);
| Arguments | Description |
|---|---|
| String reportPath | Required. Specifies the report catalog path for the report. |
| String sessionID | Optional. Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
If present, report ADF parameters for the following objects, in the order listed:
Prompts
Unprotected filters
Presentation variables referenced in the report
Context variables referenced by the Oracle Business Intelligence Presentation Services
See also, "ReportADFParameters Structure."
Use this service to provide authentication methods such as logon and logoff, and other session-related methods.
Table 3-13 shows the supported methods.
Table 3-13 SAWSessionService Methods
| Method Name | Description |
|---|---|
|
Retrieves the current user ID for the session. |
|
|
Retrieves the environment object for the current session. |
|
|
Retrieves a list of session variables. |
|
|
Logs on and then impersonates the user. |
|
|
Logs on and then impersonates the user. Similar to the impersonate method, but impersonateex can specify optional session parameters. |
|
|
Instructs Oracle Business Intelligence Presentation Services not to end particular sessions due to inactivity. |
|
|
Logs the user off Oracle Business Intelligence Presentation Services. |
|
|
Authenticates the user. |
|
|
Authenticates the user. Similar to the logon method, but logonex can specify optional session parameters. |
Use this method to retrieve the current user name for the session.
Use this method to retrieve the environment object for the current session.
SessionEnvironment getSessionEnvironment (String sessionID);
| Arguments | Description |
|---|---|
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
This method returns a session environment object (for more information, see Section 2.57, "SessionEnvironment Structure").
Use this method to retrieve a list of session variables.
List[] getSessionVariables(List[] names, String sessionID);
| Arguments | Description |
|---|---|
| List[] names | Specifies the names of the session variables. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to log on and impersonate the user during the SAWSessionService service. This method is useful when you need to create sessions for multiple users and have only the administrator's name and password. You do not need to use the (logon) method if you use the impersonate() method.
If user authentication or impersonation fails, an exception is thrown.
String impersonate(String name, String password, String impersonateID);
| Arguments | Description |
|---|---|
| String name | Specifies the user name to log on and authenticate. |
| String password | Specifies the password for the user. If there is no password for the user, leave this field empty (void). |
| String impersonateID | Specifies the user name to impersonate the authenticated user. |
Use this method to log on and impersonate the user in the SAWSessionService service. Similar to the impersonate method, but impersonateex can specify optional session parameters. This method is useful when you need to create sessions for multiple users and have only the administrator's name and password. You do not need to use the (logon) method if you use the impersonateex() method.
If user authentication or impersonation fails, then an exception is thrown.
AuthResults impersonateex(String name, String password, String impersonateID, SAWSessionParameters sessionparams);
| Arguments | Description |
|---|---|
| String name | Specifies the user name to log on and authenticate. |
| String password | Specifies the password for the user. If there is no password for the user, leave this field empty (void). |
| String impersonateID | Specifies the user name to impersonate the authenticated user. |
| SAWSessionParameters sessionparams | Optional. Specifies the session parameters to use, supplied in the SAWSessionParameters structure. For information about the SAWSessionParameters structure, see Section 2.55, "SAWSessionParameters Structure". |
This method returns the AuthResult structure containing the session ID, and also sets an HTTP session cookie. The session ID is used in other methods to identify the Oracle Business Intelligence Presentation Services session. For more information, see Section 2.10, "AuthResult Structure".
Use this method to instruct Oracle BI EE Presentation Services not to end particular web user sessions due to inactivity. The effect of this method on session lifetime is the same as if those users performed an activity in the browser such as clicking an analysis, or invoking a method.
Use this method to log off the user from Oracle BI EE Presentation Services.
Use this method to authenticate the user. If authentication fails, an exception is thrown.
Use this method to authenticate the user. Logonex() to the logon method, but logonex can specify optional session parameters. If authentication fails, an exception is thrown.
AuthResult logonex(String name, String password, SAWSessionParameters sessionparams);
| Arguments | Description |
|---|---|
| String name | Specifies the user name to authenticate. |
| String password | Specifies the password for the user. If there is no password, leave this field empty (void). |
| SAWSessionParameters sessionparams | Optional. Specifies the sessionparams to use, supplied in the SAWSessionParameters structure. For information about the SAWSessionParameters structure, see Section 2.55, "SAWSessionParameters Structure". |
The following terms are associated with the SchedulerService service:
Agents (or iBots) - These are Presentation Services catalog objects.
Jobs - These are scheduler objects, and every agent has at least one job stored in the BI_PLATFORM schema.
JobInstances - These are scheduler objects representing active or completed jobs and are stored in the BI_PLATFORM schema.
Use this service to list, and detail scheduler jobs and job instances, and to purge and remove job instances (removing a job automatically purges job instances). Deleting agents automatically removes jobs.
To use this service, you must obtain a user session ID to return a list of Job or Job Instance Reference ID's, which you use to get details or remove the object. You obtain a user session ID by using the logon() method of the SAW session service (for more information, see Section 3.9.8, "logon() Method"). You must then apply filters to specify particular Job Reference IDs and Job Instance IDs.
For examples of using the SchedulerService service methods, see Section 3.10.8, "Examples of Using the SchedulerService API"
The client must be granted the privileges Access SOAP, and Access SchedulerService Service to call methods in the SchedulerService service API. These privileges are granted by default to the BIConsumer application role. You manage these privileges using the Manage Privileges Page in Presentation Services Administration. For more information, see "Using Presentation Services Administration" in Oracle Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition.
The methods described in this section are synchronous unless stated otherwise.
Table 3-5 shows the supported methods.
Table 3-14 SchedulerService Methods
| Method Names | Description |
|---|---|
|
Returns a list of Jobs that match the selection criteria in the specified filter argument. |
|
|
Returns a list of Job Instances that match the selection criteria in the specified filter argument. |
|
|
Returns a Job definition for a specified Job reference. |
|
|
Returns Job Instance details for a specified Job Reference. |
|
|
Requests to cancel an executing Job Instance for a specified Job Reference. |
|
|
Requests to remove a Job definition for a specified Job Reference. |
|
|
Requests to purge an existing Job Instance for a specified Job Reference. |
Use this method to get a list of job references based on a filter.
Returned references are not live and are invalidated when jobs or instances are deleted.
JobReference[] getJobReferences(List[] JobFilter, String SessionID);
| Arguments | Description |
|---|---|
| List[] JobFilter | Selection criteria that returns matching job references. An empty JobFilter results in all job references being returned. Note that filters are applied in the context of the calling user, which means that a user is restricted to listing jobs within their tenancy but does not require any Presentation Services catalog permissions on the agent corresponding to the job.
For more information, see Section 2.23, "JobFilter Structure", and Section 2.27, "JobReferenceAndInstanceReferences Structure". |
| String SessionID | Specifies the session ID, which is usually returned by the login method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. If no Session IDs are specified then all JobReferences are returned. |
Use this method to get a list of job instances that correspond to running, cancelled or completed jobs. The JobInstanceFilter must include one or more Job References (unknown Job References are ignored).
A structure is returned in the list for each Job which has associated Job Instances that satisfy the filter. For example, if the method is invoked with a JobInstanceFilter that specifies three Job references, and two of these Jobs are found to have associated Job Instances, then there will be two JobReferenceAndInstanceReferences structures returned in the list.
There is no limit to the number of structures and job instances that can be returned. Performance of this method is critical and must be optimized to allow efficient polling of job status.
References are not live and are invalidated if jobs or instances are deleted or cancelled.
The following properties can be applied when listing job instance references:
List of JobReference [Mandatory]. For more information, see Section 2.27, "JobReferenceAndInstanceReferences Structure"
JobInstanceStatus [Optional] For more information, see Section 2.26, "JobInstanceStatus Enumeration".
JobFilter, JobInstanceFilter, and PurgeJobInstancesFilter properties are selection criteria that are used as follows:
A filter is always applied in the context of the current user.
Properties in the filter are selection criteria.
Filter and its properties must be populated according to the schema.
If the selection criteria are valid, but would return Jobs that are not visible to the current user these jobs is excluded without error.
All properties in a filter is used as selection criteria (union).
Filter criteria are applied by the server at the time the request is serviced.
For more information, see Section 2.23, "JobFilter Structure", Section 2.25, "JobInstanceFilter Structure", and Section 2.40, "PurgeJobInstancesFilter Structure".
JobReferenceAndInstanceReferences[] getJobInstanceReferences(Array JobInstanceFilter, String SessionID);
| Arguments | Description |
|---|---|
| JobInstanceFilter filter | Specifies the selection criteria that determines which JobInstanceReferences to return. For more information, see Section 2.25, "JobInstanceFilter Structure" and Section 2.27, "JobReferenceAndInstanceReferences Structure". |
| String SessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to get the Job definition given a Job Reference. If you try to get a job that does not exist, a Job not found fault is raised.
Job[] getJob(String JobReference, String SessionID);
| Arguments | Description |
|---|---|
| String JobReference | Specifies a unique job identifier. For more information, see Section 2.22, "Job Structure". |
| String SessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to get the Job Instance details, when given a Job Instance Reference. If you try to get a Job Instance that does not exist, a JobInstance not found error is raised.
JobInstance[] getJobInstance(String JobReference, String JobInstanceReference, String SessionID);
| Arguments | Description |
|---|---|
| String JobReference | Specifies a unique job identifier. For more information, see Section 2.24, "JobInstance Structure". |
| String JobInstanceReference | Specifies a unique job instance identifier. |
| String SessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to request to cancel an executing Job Instance, when given a reference to an existing Job Instance.
Successful return indicates that the cancellation request has been accepted. Callers must use the getJobInstanceReferences operation (with an appropriate filter - such as Job Reference and State) or using the getJobInstance operation (and checking the JobInstanceStatus property), to determine if the cancellation has completed.
Cancelling a Job Instance that is not running has no effect. Cancelling a Job Instance that does not exist raises a JobInstance not found error.
Boolean cancelJobInstance(String JobReference, String JobInstanceReference, String SessionID);
| Arguments | Description |
|---|---|
| String JobReference | Specifies a unique job identifier. |
| String JobInstanceReference | Specifies a unique job instance identifier. For more information, see Section 2.27, "JobReferenceAndInstanceReferences Structure". |
| String SessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to remove associated jobs, given a list of Job References. If you try to remove a job that does not exist, it will be ignored and logged. The number of Jobs actually removed is returned.
Unsigned Integer removeJobs(List JobReference[], String SessionID);
| Arguments | Description |
|---|---|
| List JobReference[] | Specifies the job identifiers of the removed jobs. For more information, see Section 2.27, "JobReferenceAndInstanceReferences Structure". |
| String SessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to purge Job Instances based on a filter. The purgeJobInstancesFilter must contain either a populated list of Job References or UserIDs, and if this is not done correctly then it will result in an Invalid Choice SOAP fault being raised. Attempting to purge with a Job Reference or UserID that does not exist will be ignored and logged.
The following properties can be applied when purging job instances:
Choice of only one of the following: [Mandatory]:
List of Job Reference [Optional].
List of User IDs [Optional].
Void purgeJobinstances(List[] PurgeJobInstancesFilter, String SessionID);
| Arguments | Description |
|---|---|
| List[] PurgeJobInstancesFilter | Specifies filter properties for the Job Instances to purge. For more information, see Section 2.40, "PurgeJobInstancesFilter Structure". |
| String SessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
This section assumes that the reader is familiar with Java and SOAP based web services. The Java code that follows is intended to illustrate API usage.
Section 3.10.8.1, "Example - Creating a Session and Scheduler Service"
Section 3.10.8.2, "Example - Finding Job References for a User and Displaying the Job Names"
Section 3.10.8.3, "Example - Finding Job Instances for Two Given Job References"
Section 3.10.8.4, "Example - Cancelling All Job Instances Associated with a Job Reference"
Section 3.10.8.5, "Example - Finding and Displaying all Agents in the WebCatalogService"
As with all services detailed here, to use the scheduler service you must first establish a SAWSession, then instantiate a handle to the service endpoint:
SAWSessionService sessionService = new SAWSessionService();
SAWSessionServiceSoap sessionServiceSoap = sessionService.getSAWSessionServiceSoap();
String sessionId = sessionServiceSoap.logon("<USER_NAME>", "<PASSWORD>");
SchedulerService schedulerService = new SchedulerService();
SchedulerServiceSoap schedulerServiceSoap = schedulerService.getSchedulerServiceSoap();
This example depends on the code from Section 3.10.8.1, "Example - Creating a Session and Scheduler Service" to create the session and service.
JobFilter jobFilter = new JobFilter();
jobFilter.getUserID().add("<USER_ID>");
List<Long> jobRefs = schedulerServiceSoap.getJobReferences(jobFilter, sessionId);
for (long jobRef : jobRefs)
{
Job job = schedulerServiceSoap.getJob(jobRef, sessionId);
System.out.println("Name = " + job.getName());
}
This example depends on the code from Section 3.10.8.1, "Example - Creating a Session and Scheduler Service" to create the session and service.
// Create Job Instance Filter
JobInstanceFilter jobInstanceFilter = new JobInstanceFilter();
jobInstanceFilter.getJobReference().add(<JOB_REFERENCE_1>);
jobInstanceFilter.getJobReference().add(<JOB_REFERENCE_2>);
jobInstanceFilter.setJobInstanceStatus(null);
List<JobReferenceAndInstanceReferences> listJobRefAndInstanceRefs = schedulerServiceSoap.getJobInstanceReferences(jobInstanceFilter, sessionId);
System.out.println("Number of Jobs with Instances found: " + listJobRefAndInstanceRefs.size());
for (JobReferenceAndInstanceReferences jobRefAndInstanceRefs : listJobRefAndInstanceRefs)
{
System.out.println("Job Ref = " +
jobRefAndInstanceRefs.getJobReference() + ", Job Instance Refs = " +
jobRefAndInstanceRefs.getJobInstanceReference());
}
This example cancels all Job Instances for the Job with the given Job Reference. This example also depends on the code from Section 3.10.8.1, "Example - Creating a Session and Scheduler Service" to create the session and service.
// Create Job Instance Filter
JobInstanceFilter jobInstanceFilter = new JobInstanceFilter();
jobInstanceFilter.getJobReference().add(<JOB_REFERENCE>);
// Get JobInstance References
List<JobReferenceAndInstanceReferences> listJobRefAndInstanceRefs = schedulerServiceSoap.getJobInstanceReferences(jobInstanceFilter, sessionId);
// Cancel all the obtained Job Instances
for (JobReferenceAndInstanceReferences jobRefAndInstanceRefs : listJobRefAndInstanceRefs)
{
for (BigInteger jobInstanceRef : jobRefAndInstanceRefs.getJobInstanceReference())
{
System.out.println("Cancelling Job = " + jobRefAndInstanceRefs.getJobReference() + ", Job Instance = " + jobInstanceRef);
boolean result = schedulerServiceSoap.cancelJobInstance(jobRef, jobInstanceRef, sessionId);
System.out.println("Result = " + result);
}
}
This example shows how to iterate through the WebCatalogService and display the path of all the agents found. This example also depends on the code from Section 3.10.8.1, "Example - Creating a Session and Scheduler Service" to create the session and service.
You could extend this example, so that once an agent has been found, it can be used to call iBot web service methods (for example, Enable the Agent using the Agent path found). Section 3.4, "iBotService Service"
WebCatalogService webCatalogService = new WebCatalogService();
WebCatalogServiceSoap webCatalogServiceSoap = webCatalogService.getWebCatalogServiceSoap();
void outputAgentsInFolder(String path) { List<ItemInfo> items = null; try { // Get folder items items = webCatalogServiceSoap.getSubItems(path, "*", false, null, sessionId); for (ItemInfo itemInfo : items) { // If item is Agent then display Agent path if (itemInfo.getSignature().equals("coibot1")) { System.out.println("Agent Path = " + itemInfo.getPath()); } // If item is a folder then recurse if (itemInfo.getType() == ItemInfoType.FOLDER) { outputAgentsInFolder (itemInfo.getPath()); } }} catch (SOAPFaultException soapFault){ System.out.println("SOAP Fault for path: " + path);} catch (Exception e) { e.printStackTrace(); }}
Use this service to provide methods for the scorecard assessment engine web service. Table 3-15 shows the supported methods.
Table 3-15 ScorecardAssessmentService Methods
| Method Names | Description |
|---|---|
|
Exposes the scorecard assessment engine web service's executeScorecard method. |
|
|
Retrieves assessments for one or more of the scorecard's trees in their entirety. |
|
|
Generates an Oracle Business Intelligence report containing a detail report for the specified KPI. |
|
|
Returns the set of dimensions that are related to the KPIs currently in use by the strategy and initiative trees. |
Use this method to expose the scorecard assessment engine web service's executeScorecard method.
AssessmentResult[] executeScorecard(String ScorecardPath, Array NodeInfos, Array Variables, Boolean GetFresh, Session sessionID);
For more information about AssessmentResult[], see Section 2.9, "AssessmentResult Structure".
| Arguments | Description |
|---|---|
| String ScorecardPath | Specifies the Presentation Services catalog path identifying the folder containing the scorecard you want to assess. |
| Array NodeInfos | Specifies an array of nodes for which you need assessments. For more information, see Section 2.34.1, "NodeTypes Enumeration". |
| Variable[] Variables | Specifies an array of Variable objects that you want to apply in the query. For more information, see Section 2.64, "Variable Structure". |
| Boolean GetFresh | (Optional) Specifies whether server side Presentation Services cache should be hit (true), or not (false)? Defaults to false. |
| Session sessionID | (Optional) Specifies the SAW Session ID. This parameter can usually be omitted as the session ID is stored as a cookie. |
Use this method to retrieve assessments for one or more of the scorecard's trees in their entirety.
AssessmentResult[] executeScorecardTree(String ScorecardPath, Integer TreesFlag, Array Variables, Boolean GetFresh, Session sessionID);
| Arguments | Description |
|---|---|
| String ScorecardPath | Specifies the Presentation Services catalog path identifying the folder containing the scorecard you want to assess. |
| Integer TreesFlag | Specifies an integer indicating which trees you are interested in. Use the "bitwise or" operator (|) with the values of TreeFlags corresponding to the trees you are interested in to arrive at the integer value you need. For more information, see Section 2.59, "TreeFlags Enumeration". |
| Variable[] Variables | Specifies an array of Variable objects that you want to apply in the query. For more information, see Section 2.64, "Variable Structure". |
| String sessionID | (Optional) Specifies the SAW session ID. This parameter can usually be omitted as the session ID is stored as a cookie. |
Use this method to generate an Oracle Business Intelligence report containing a detail report for the specified KPI.
DrillToReportURLResult generateKPIDrillTo(String ScorecardPath, String NodeID, String NodeType, String ReportPath, Array Variables, Boolean IsDrillToReport, chartHeight, chartWidth, Session sessionID);
| Arguments | Description |
|---|---|
| String ScorecardPath | Specifies the path to the scorecard folder containing the strategy tree or initiative tree the specified KPI is pinned to. |
| String NodeID | Specifies the GUID for the pinned KPI's node in the strategy or initiative tree. |
| String NodeType | Specifies the type of tree a node belongs to. For more information about possible values, see Section 2.34.1, "NodeTypes Enumeration". |
| String ReportPath | Specifies the web catalog path where the generated report should be saved. |
| Array Variables | Specifies an array of Variable structure objects that should be used when generating the report. For more information, see Section 2.64, "Variable Structure". |
| Boolean IsDrillToReport | Specifies if it is a drilltoreport (true), or if it is a detail report (false). |
| chartHeight | Specifies chart height. |
| chartWidth | Specifies chart width. |
| String sessionID | (Optional) Specifies the SAW Session ID. This parameter can usually be omitted as the session ID is stored in a cookie. |
Use this method to return the set of dimensions that are related to the KPIs currently in use by the strategy and initiative trees.
ScorecardDimensionReference[] getScorecardKPIDimensions(Boolean GetFresh, Session sessionID);
| Arguments | Description |
|---|---|
| Boolean GetFresh | (Optional) Specifies whether the results must be freshly retrieved from the middle-tier (true) or whether the cached list is sufficient (false). Default: false. |
| Session sessionID | (Optional) Specifies the HTTP Session ID that should be used to make the request. Default: The current HTTP session (as identified by the session cookie). |
Use this service to provide methods for the ScorecardMetadataService SOAP API for creating, updating and deleting Scorecard Metadata in the Oracle BI Presentation Services Catalog. Table 3-16 shows the supported methods.
Table 3-16 ScorecardMetadataService Methods
| Method Names | Description |
|---|---|
|
Creates a scorecard. |
|
|
Opens a scorecard (in read only mode). |
|
|
Closes a scorecard. |
|
|
Edits a scorecard (opens in read-write mode). |
|
|
Retrieves scorecard details. |
|
|
Updates scorecard settings. |
|
|
Adds a strategy node to a specified scorecard. |
|
|
Deletes a strategy node from a specified scorecard. |
|
|
Updates a strategy node for a specified scorecard. |
|
|
Moves a strategy node to a new parent node in a specified scorecard. |
|
|
Adds an initiative node to a specified scorecard. |
|
|
Deletes an initiative node from a specified scorecard. |
|
|
Moves an initiative node to a new parent node in a specified scorecard. |
|
|
Reads the information for a particular strategy or initiative node within a specific scorecard. |
|
|
Adds a perspective to a specified scorecard. |
|
|
Deletes a perspective from a specified scorecard. |
|
|
Updates a perspective in a specified scorecard. |
|
|
Adds a scorecard view to a specified scorecard. |
|
|
Updates a scorecard view in a specified scorecard. |
|
|
Deletes a scorecard view from a specified scorecard. |
|
|
Updates the causal linkages in the specified scorecard. |
|
|
Updates the Access Control List (ACL) for an item in the specified scorecard. |
Use this method to create a scorecard.
CreateScorecardResult createScorecard(String Name, String Description, String Path, String RootNodeName, Boolean UseDefaultPerspectives, String SessionID);
| Arguments | Description |
|---|---|
| String Name | Specifies the name you want to give to the new scorecard. |
| String Description | Specifies the description you want to give to the new scorecard. |
| String Path | Specifies the catalog path where you want to save the new scorecard. |
| String RootNodeName | Specifies the name that you want to give to the root node of the new scorecard's strategy tree. |
| Boolean UseDefaultPerspectives | Specifies whether the scorecard should be pre populated with the default perspectives (true) or not (false). |
| String SessionID | (Optional) Specifies the HTTP session ID. |
Use this method to open a scorecard.
OpenScorecardResult openScorecard(String Path, Boolean RequestedReadWrite, Object RetryOrigResult, String SessionID);
| Arguments | Description |
|---|---|
| String Path | Specifies the catalog path of the scorecard you want to open. |
| Boolean RequestedReadWrite | Specifies whether you want to open the scorecard in Edit mode (true) or View mode (false). |
| String SessionID | (Optional) Specifies the HTTP session ID. |
Use this method to close a scorecard.
CloseScorecardResult closeScorecard(String ScorecardID, String ErrorCode, String ErrorMessage);
| Arguments | Description |
|---|---|
| String ScorecardID | Specifies the ID of the scorecard you want to close. |
| Boolean Unlock | Specifies whether you want to unlock the scorecard (true) or not (false). |
| String SessionID | (Optional) Specifies the HTTP session ID. |
Use this method to edit a scorecard.
OpenScorecardResult editScorecard(String Path, String ScorecardID, Boolean Edit, String SessionID);
| Arguments | Description |
|---|---|
| String Path | Specifies the catalog path of the scorecard you want to open. |
| String ScorecardID | Specifies the ID of the scorecard you want to close. |
| Boolean Edit | Specifies whether you want to open the scorecard in Edit mode (true) or View mode (false). |
| String SessionID | (Optional) Specifies the HTTP session ID. |
Use this method to retrieve scorecard details.
GetScorecardDetailsResult getScorecardDetails(String ScorecardID, Boolean GetSettings, Boolean GetPerspectives, Boolean GetStrategyTree, Boolean GetInitiativeTree, Boolean GetCausalLinkages, Boolean GetViews, Boolean IncludeCatalogObjects, String SessionID);
| Arguments | Description |
|---|---|
| String ScorecardID | The ID of the Scorecard you are interested in. |
| Boolean GetSettings | Specifies whether you want the results to include the Scorecard Settings (true) or not (false). |
| Boolean GetPerspectives | Specifies whether you want the results to include the Scorecard's Perspectives (true) or not (false). |
| Boolean GetStrategyTree | Specifies whether you want the results to include the Scorecard's Strategy Tree (true) or not (false). |
| Boolean GetInitiativeTree | Specifies whether you want the results to include the Scorecard's Initiative Tree (true) or not (false). |
| Boolean GetCausalLinkages | Specifies hether you want the results to include the Scorecard's Causal Linkages (true) or not (false). |
| Boolean GetViews | Specifies whether you want the results to include the Scorecard's Views (true) or not (false). |
| Boolean IncludeCatalogObjects | Specifies whether you want the results to include the Scorecard's Catalog Objects (true) or not (false). |
| String SessionID | (Optional) Specifies the HTTP session ID. |
Use this method to update scorecard settings.
void updateScorecardSettings(String ScorecardID, Object ScorecardSettings, String SessionID);
| Arguments | Description |
|---|---|
| String ScorecardID | Specifies the ID of the Scorecard you want to update. |
| Object ScorecardSettings | Specifies the new scorecard settings that you want to apply. |
| String SessionID | (Optional) Specifies he HTTP session ID. |
Use this method to add a strategy node to the specified scorecard.
ObjectiveNode (or PinnedKPINode) addStrategyNode(String ScorecardID, Object StrategyNode, String SessionID);
| Arguments | Description |
|---|---|
| String ScorecardID | Specifies the ID of the Scorecard you want to add the strategy node to. |
| Object StrategyNode | Specifies the strategy node that you want to add. |
| String SessionID | (Optional) Specifies the HTTP session ID. |
Use this method to delete a strategy node from a specified scorecard.
DeleteNodeResult deleteStrategyNode(String ScorecardID, String NodeID, Boolean RemoveLinkedObjective, Boolean Recursive, String SessionID);
| Arguments | Description |
|---|---|
| String ScorecardID | Specifies the ID of the Scorecard you want to remove the strategy node from. |
| String NodeID | Specifies the ID of the node you want to delete. |
| Boolean RemoveLinkedObjective | Specifies whether you want to delete all the nodes linked to the specified node (true) or not (false). |
| Boolean Recursive | Specifies whether you want to delete all the nodes beneath the specified node (true) or not (false). |
| String SessionID | (Optional) Specifies the HTTP session ID. |
Use this method to update a strategy node in the specified scorecard.
ObjectiveNode (or PinnedKPINode) updateStrategyNode(String ScorecardID, Object StrategyNode, String SessionID);
| Arguments | Description |
|---|---|
| String ScorecardID | Specifies the ID of the Scorecard containing the strategy node you want to update. |
| Object StrategyNode | Specifies the strategy node that you want to update. |
| String SessionID | (Optional) Specifies the HTTP session ID. |
Use this method to move a strategy node to a new parent node in the specified scorecard.
MoveNodeResult moveStrategyNode(String ScorecardID, String NodeToBeMovedGuid, String OriginalParentGuid, String ReferenceNodeGuid, String NewParentGuid, String Operation, String SessionID);
| Arguments | Description |
|---|---|
| String ScorecardID | Specifies the ID of the Scorecard containing the strategy node you want to move. |
| String NodeToBeMovedGuid | Specifies the ID of the node you want to move. |
| String OriginalParentGuid | Specifies the ID of the old parent node. |
| String ReferenceNodeGuid | Specifies the ID of the reference node (this is used with respect to the specified operation to determine the final resting place of the moved node). |
| String NewParentGuid | Specifies he ID of the new parent node. |
| String Operation | Specifies the move operation to apply. Specifies the operation ADD, UPDATE, or DELETE. |
| String SessionID | (Optional) Specifies he HTTP session ID. |
Use this method to add an initiative node to the specified scorecard.
InitiativeNode (or PinnedKPINode) addInitiativeNode(String ScorecardID, Object InitiativeNode, String SessionID);
| Arguments | Description |
|---|---|
| String ScorecardID | Specifies the ID of the Scorecard you want to add the initiative node to. |
| Object InitiativeNode | Specifies the initiative node that you want to add. |
| String SessionID | (Optional) Specifies the HTTP session ID. |
Use this method to delete an initiative node from the specified scorecard.
DeleteNodeResult deleteInitiativeNode(String ScorecardID, String NodeID, Boolean RemoveLinkedInitiative, Boolean Recursive, String SessionID);
| Arguments | Description |
|---|---|
| String ScorecardID | Specifies the ID of the Scorecard you want to remove the initiative node from. |
| String NodeID | Specifies the ID of the node that you want to delete. |
| Boolean RemoveLinkedInitiative | Specifies whether you want to delete all the nodes linked to the specified node (true) or not (false). |
| Boolean Recursive | Specifies whether you want to delete all the nodes beneath the specified node (true) or not (false). |
| String SessionID | (Optional) Specifies the HTTP session ID. |
Use this method to move an initiative node to a new parent node in the specified scorecard.
MoveNodeResult moveInitiativeNode(String ScorecardID, String NodeToBeMovedGuid, String OriginalParentGuid, String ReferenceNodeGuid, String NewParentGuid, String Operation, String SessionID);
| Arguments | Description |
|---|---|
| String ScorecardID | Specifies the ID of the Scorecard containing the strategy node you want to move. |
| String NodeToBeMovedGuid | Specifies the ID of the node you want to move. |
| String OriginalParentGuid | Specifies the ID of the old parent node. |
| String ReferenceNodeGuid | Specifies the ID of the reference node (this is used with respect to the specified operation to determine the final resting place of the moved node). |
| String NewParentGuid | Specifies the ID of the new parent node. |
| String Operation | Specifies the move operation to apply. Specifies the operation ADD, UPDATE, or DELETE. |
| String SessionID | (Optional) Specifies the HTTP session ID. |
Use this method to read the information for a particular strategy or initiative node within a specific scorecard.
openTreeNode(String scorecardID, String nodeID, String type, String sessionID);
| Arguments | Description |
|---|---|
| String scorecardID | Specifies the ID of the scorecard node you want to open. |
| String nodeID | Specifies the ID of the Strategy or Initiative node. |
| String type | Specifies the type of the node ("OBJECTIVE_NODE" or "INITIATIVE_NODE"). |
| String sessionID | (Optional) Specifies the HTTP session ID. |
Use this method to add a perspective to a scorecard.
Perspective addPerspective(String ScorecardID, Object InitiativeNode, String SessionID);
| Arguments | Description |
|---|---|
| String ScorecardID | Specifies the ID of the Scorecard you want to add the perspective to. |
| Object Perspective | Specifies the perspective you want to add. |
| String SessionID | (Optional) Specifies he HTTP session ID. |
Use this method to delete a perspective from the specified scorecard.
DeletePerspectiveResult deleteInitiativeNode(String ScorecardID, String PerspectiveID, String SessionID);
| Arguments | Description |
|---|---|
| String ScorecardID | Specifies the ID of the Scorecard you want to remove the perspective from. |
| String PerspectiveID | Specifies the ID of the perspective you want to delete. |
| String SessionID | (Optional) Specifies the HTTP session ID. |
Use this method to update a perspective in the specified scorecard.
Perspective updatePerspective(String ScorecardID, Object Perspective, String SessionID);
| Arguments | Description |
|---|---|
| String ScorecardID | Specifies the ID of the Scorecard containing the perspective you want to update. |
| Object Perspective | Specifies the perspective you want to update. |
| String SessionID | (Optional) Specifies the HTTP session ID. |
Use this method to add a scorecard view to the specified scorecard.
ItemInfo addScorecardView(String ScorecardID, Object XMLDocumentInfo, String SessionID);
| Arguments | Description |
|---|---|
| String ScorecardID | Specifies the ID of the Scorecard you want to add a scorecard view to. |
| Object XMLDocumentInfo | Specifies the object containing the new view's metadata. |
| String SessionID | (Optional) Specifies the HTTP session ID. |
Use this method to update a scorecard view in the specified scorecard.
ItemInfo updateScorecardView(String ScorecardID, Object XMLDocumentInfo, String SessionID);
| Arguments | Description |
|---|---|
| String ScorecardID | Specifies the ID of the Scorecard containing the view you want to update. |
| Object XMLDocumentInfo | Specifies the object containing the updated view's metadata. |
| String SessionID | (Optional) Specifies the HTTP session ID. |
Use this method to delete a scorecard view from the specified scorecard.
DeleteScorecardViewResult deleteScorecardView(String ScorecardID, String Path, String SessionID);
| Arguments | Description |
|---|---|
| String ScorecardID | Specifies the ID of the Scorecard containing the view you want to delete. |
| String Path | Specifies the catalog path of the view you want to delete. |
| String SessionID | (Optional) Specifies the HTTP session ID. |
Use this method to update the causal linkages in the specified scorecard.
UpdateCausalLinkageResult updateCausalLinkages(String Name, Array CausalLinkage, String SessionID);
| Arguments | Description |
|---|---|
| String ScorecardID | Specifies the ID of the Scorecard containing the causal linkages you want to update. |
| Array CausalLinkage[] | Specifies an array of CausalLinkage structure objects that you want to update. For more information, see Section 2.13, "CausalLinkage Structure". |
| String SessionID | (Optional) Specifies the HTTP session ID. |
Use this method to update the Access Control List (ACL) for an item in the specified scorecard.
UpdateScorecardItemACLResult updateScorecardItemACL(String ScorecardID, Enumeration Type, String Path, String id, ACL acl, UpdateCatalogItemACLParams options, String SessionID);
| Arguments | Description |
|---|---|
| String ScorecardID | Specifies the ID of the Scorecard containing the item whose ACL you want to update. |
| Enumeration Type | Specifies what type of object is having its ACL updated.
The Type field can be the following valid values: SCORECARD, STRATEGY_NODE, and INITIATIVE_NODE types. |
| String id | Specifies a scorecard tree NODE GUID which is only needed for Strategy Tree or Initiative Tree ACLs (when Type is STRATEGY_NODE or INITIATIVE_NODE). It can be null for other catalog types. |
| String Path | Specifies the path to the object whose ACL you want to update. |
| ACL acl | Specifies the new ACL. For more information, see Section 2.3, "ACL Structure". |
| UpdateCatalogItemACLParams options | The 'options' UpdateCatalogItemACLParams structure contains the UpdateACLMode and Recursive flags and is of type UpdateCatalogItemACLParams. For more information, see Section 2.62, "UpdateCatalogItemACLParams Structure". |
| String SessionID | (Optional) Specifies the HTTP session ID. |
Use this service to provide methods for identifying accounts and privileges. Table 3-17 shows the supported methods.
Table 3-17 SecurityService Methods
| Method Names | Description |
|---|---|
|
Removes accounts from the catalog. |
|
|
Searches for Oracle BI EE user accounts. |
|
|
Gets the tenant ID of a specific account. |
|
|
Gets the Access Control List for global privileges. |
|
|
Gets the list of all global privileges. |
|
|
Gets a list of catalog groups that are members of the account (for example, user or group |
|
|
Gets direct members of the catalog group. |
|
|
Get the list of permissions for the specified user. |
|
|
Get the list of permissions for the specified user. |
|
|
Lists all privileges and their statuses. |
|
|
Confirms if a catalog group is a member of the user or group. |
|
|
Adds a user to a catalog group as a member. |
|
|
Removes a member from a group. |
|
|
Changes the name of an user account. |
|
|
Updates the Access Control List for global privileges. |
Use this method to remove accounts from the catalog.
forgetAccountsStatus(ForgetAccount forgetAccountsList, String sessionID);
| Argument | Description |
|---|---|
| ForgetAccount forgetAccountsList | Specifies the accounts to forget, supplied in the ForgetAccount structure. For information about the ForgetAccount structure, see Section 2.17, "ForgetAccount Structure." |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Returns a list of account names with status of forgetAccounts operation in the ForgetAccountsStatus Structure. For more information, see Section 2.19, "ForgetAccountsStatus Structure."
Use this method to search for Oracle BI EE user accounts (for example, LDAP users, catalog groups, or application roles).
List[] getAccounts(List[], String sessionID);
| Argument | Description |
|---|---|
| List[] | Specifies user names, catalog group names, and application role names. A flag indicates if the name is a user, group, or application role. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to retrieve the tenant ID of a specific account.
List[] getAccountTenantID(List[], String sessionID);
| Argument | Description |
|---|---|
| Account account | Specifies the account for which we want tenant ID. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to retrieve the Access Control List for global privileges.
ACL getGlobalPrivilegeACL(String privilegeName, String sessionID);
| Argument | Description |
|---|---|
| String privilegeName | Specifies the name of the privilege to retrieve. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to retrieve the list of global privileges.
Use this method to get a list of catalog groups that are members of the account (for example, user or group).
List[] getGroups(List[], Boolean expandGroups, String sessionID);
| Argument | Description |
|---|---|
| List[] | Specifies user or group. |
| Boolean expandGroups | Specifies to expand the groups to which the members belong. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to get direct members of the catalog group.
List[] getMembers(List[] group, Boolean expandGroups, String sessionID);
| Argument | Description |
|---|---|
| List[] | Specifies the catalog group for which you want a list of members. |
| Boolean expandGroups | Specifies to expand the groups to which the members belong. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to retrieve a list of permissions for the specified user, based on the specified access control list.
Note:
This method also returns any permissions that are inherited by a user's security group, even if the access control list does not specify the group's permissions.List[] getPermissions(List[], Account account, String sessionID);
| Argument | Description |
|---|---|
| List[] | Specifies the access control list for the user specified by Account account. |
| Account account | Specifies the name of the user for whom to find permission for the ACLs. Can be the user's name or a GUID. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Returns permissions information in the permissionMask field in the AccessControlToken structure (for more information, see Section 2.1, "AccessControlToken Structure").
Use this method to retrieve a list of permissions for the specified user, owner, or creator, based on the specified access control list.
List[] getPermissionsEx(List[], Account account, Owner owner, Creator creator, String sessionID);
| Argument | Description |
|---|---|
| List[] | Specifies the access control list for the user specified by Account account. |
| Account account | Specifies the name of the user for whom to find permission for the ACLs. Can be the user's name or a GUID. |
| Owner owner | Specifies the name of the owner for whom to find permission for the ACLs. Can be the owner's user name or a GUID. |
| Creator creator | Specifies the name of the creator for whom to find permission for the ACLs. Can be the creator's user name or a GUID. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Returns permissions information in the permissionMask field in the AccessControlToken structure (for more information, see Section 2.1, "AccessControlToken Structure").
Use this method to list all privileges and their statuses.
List[] getPrivilegesStatus(List[] privileges, String sessionID);
| Argument | Description |
|---|---|
| List[] privileges | Specifies a list of privileges. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to confirm if a catalog group is a member of the user or group.
boolean isMember(List[] group, List[] member, Boolean expandGroups, String sessionID);
| Argument | Description |
|---|---|
| List[] group | Specifies the username, catalog group, or application role name. |
| List[] member | Specifies the name of the member to verify. Consider the example is Member(BIAdministrator, Administrator, false). This example asks if the user Administrator is a member of the BIAdministrator application role. |
| Boolean expandGroups | Specifies to expand the groups to which the members belong. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to join a catalog group as a member.
void joinGroups(List[] group, List[] member, String sessionID);
| Argument | Description |
|---|---|
| List[] group | Specifies the name of the group to join or become a member. Consider the following example: join(Marketing, UserA). This example illustrates that UserA will join the Marketing catalog group. |
| List[] member | Specifies the name of the underlying member. For more information, see the example included in the previous argument. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to remove a member from a group.
void leaveGroups(List[] group, List[] member, String sessionID);
| Argument | Description |
|---|---|
| List[] group | Specifies the group from which to remove a member. |
| List[] member | Specifies the member that you want to remove from the group. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to rename accounts.
renameAccountsStatus(RenameAccount renameAccountsList, String sessionID);
| Argument | Description |
|---|---|
| RenameAccount renameAccountsList | Specifies a list of old names and new names with their account types in the RenameAccount structure. For information about the RenameAccount structure, see "RenameAccountsStatus Structure." |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Returns a list of account names with status of renameAccounts operation in the RenameAccountsStatus Structure. For information, see "RenameAccountsStatus Structure."
Use this method to update the Access Control List for global privileges.
void updateGlobalPrivilegeACL(String privilegeName, ACL acl, UpdateACLParams updateACLParams, String sessionID);
| Arguments | Description |
|---|---|
| String privilegeName | Specifies the name of privilege to update. |
| ACL acl | Specifies the Access Control List to update, supplied in the ACL structure. For information about the ACL structure, see Section 2.3, "ACL Structure". |
| UpdateACLParams updateACLParams | Specifies the Access Control List parameters to update, supplied in the UpdateACLParams structure. For information about the UpdateACLParams structure, see Section 2.61, "UpdateACLParams Structure". |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this service to manage favorites and favorite categories. Table 3-18 shows the supported methods.
Table 3-18 UserPersonalizationService Methods
| Method Names | Description |
|---|---|
|
Adds a catalog object as a favorite in favorite list. |
|
|
Adds a category object in favorite manager. |
|
|
Deletes an existing favorite item from favorite manager. |
|
|
Deletes an existing favorite category from favorite manager. |
|
|
Returns all existing favorite items and category. |
|
|
Removes all existing favorite items and category and regenerates all favorite manager items using the supplied list of favorite items. |
|
|
Returns all most recent used items. |
Use this method to add a catalog object as favorite in the favorite list.
void addFavorite(String catalogObjectPath, String categoryPath, String sessionID);
| Arguments | Description |
|---|---|
| String catalogObjectPath | Specifies the catalog object path to add as a favorite. |
| String categoryPath | Specifies the category location (in favorite manager) to create the favorite item. If blank, the favorite item is added as a root element in favorite manager. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to add a category object in favorite manager.
void addFavoriteCategory(String categoryName, String categoryPath, String sessionID);
| Arguments | Description |
|---|---|
| String categoryName | Specifies the catalog object path to add as a favorite. |
| String categoryPath | Specifies the category location (in favorite manager) to create new category. If empty, new category will be added on root of favorite manager. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to delete an existing favorite item from favorite manager.
void deleteFavorite(String catalogObjectPath, String categoryPath, String sessionID);
| Arguments | Description |
|---|---|
| String catalogObjectPath | Specifies the catalog object path for which to delete the favorite item. |
| String categoryPath | Specifies the category location (in favorite manager) from where favorite item needs to be deleted. If empty, catalog object will be removed from all categories, that is, it will be marked as non favorite object. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to delete an existing favorite category from favorite manager.
void deleteFavoriteCategory(String categoryPath, String sessionID);
| Arguments | Description |
|---|---|
| String categoryPath | Specifies the complete category path (in favorite manager) that needs to be deleted. This path starts from /root. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to return all existing favorite items and category.
List[] getFavorites(String categoryPath, boolean recursive, boolean categoryOnly, String sessionID);
| Arguments | Description |
|---|---|
| String categoryPath | Specifies the category location (in favorite manager) to create favorite item. If blank, favorite item is added as root element in favorite manager. |
| Boolean recursive | Specifies whether the child-level categories were included in the result. |
| Boolean categoryOnly | Specifies if only categories were included in the result and excluding all favorite items. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to remove all existing favorite items and category, and regenerate all favorite manager items using supplied list of favorite items.
void updateFavorites(List [] favoriteItems, String sessionID);
| Arguments | Description |
|---|---|
| List [] favoriteItems | Specifies a list of FavoriteItem structure, for more information, see Section 2.17, "ForgetAccount Structure". In this FavoriteItem structure, there is no need to fill ItemInfo structure (see Section 2.21, "ItemInfo Structure"), only name, path and type parameters are mandatory. The catalogPath argument is required to add a catalog object in favorite manager. Additionally for optional subItems, you can include a nested FavoriteItem list. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to return all most recent used items.
List[] getMostRecents(UnsignedShort listType, String sessionID);
| Arguments | Description |
|---|---|
| UnsignedShort listType | listType value is as following flags:
1 = Recently Updated 2 = Recently Viewed 3 = Frequently Viewed 4 = Recent 5 = Suggestions |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this service to provide methods for navigating and managing the catalog, and to read and write catalog objects in XML format. Table 3-19 shows the supported enumerations and methods.
Table 3-19 WebCatalogService Enumerations and Methods
| Enumeration and Method Names | Description |
|---|---|
|
Specifies a list of valid values for methods. |
|
|
Specifies a list of valid values for methods. |
|
|
Copies an object from one location to another in the catalog. |
|
|
Generates an archive file from the catalog. |
|
|
Creates a new folder in the catalog. |
|
|
Creates a link to the catalog. |
|
|
Deletes an object from the catalog. |
|
|
Retrieves catalog information for an object. |
|
|
Retrieves the maintenance mode status. |
|
|
Retrieves all supported categories. |
|
|
Retrieves all creatable objects. |
|
|
Retrieves all supported catalog object types. |
|
|
Retrieves the collection of child subitems for an object in the catalog. |
|
|
Retrieves the home directory path of a user. |
|
|
Locks the catalog during maintenance. |
|
|
Moves an object in the catalog to a different location in the catalog. |
|
|
Pastes the copied items. |
|
|
Reads an object from the catalog. |
|
|
Deletes a folder from the catalog. |
|
|
Sets attribute flags for the specified catalog item. |
|
|
Sets a property for an object in the catalog. |
|
|
Take ownership of the specified item. |
|
|
Update the Access Control List for an item in the catalog. |
|
|
Writes a list of objects to the catalog. |
This enumeration specifies a list of valid values for methods in the "WebCatalogService Service". Table 3-20 lists the values in this enumeration.
Note:
Only one of the values in ErrorDetailsLevel should be selected.Table 3-20 ErrorDetailsLevel Enumeration Values
| Values | Description |
|---|---|
|
String ErrorCode |
Specifies that the ErrorInfo.errorCode field is populated. |
|
String ErrorCodeAndText |
Specifies that the ErrorInfo.errorCode and ErrorInfo.message fields are populated. |
|
String FullDetails |
Specifies that all ErrorInfo fields are populated. |
This enumeration specifies a list of valid values for methods in the "WebCatalogService Service". Table 3-21 lists the values in this enumeration.
Table 3-21 ReadObjectsReturnOptions Enumeration Values
| Values | Description |
|---|---|
|
String NoObject |
Specifies that the catalogObject and catalogObjectBytes fields are not populated. |
|
String ObjectAsString |
Specifies that the catalogObject field is populated and the catalogObjectBytes fields is not populated. |
|
String ObjectAsBinary |
Specifies that the catalogObject field is not populated and the catalogObjectBytes fields is populated. |
|
String ObjectAsBinaryUseMtom |
Specifies that the catalogObject field is not populated and the catalogObjectBytes fields is populated and using MTOM to encode the content returned by the SOAP message. |
Use this method to copy an object from one location in the catalog to another location in the catalog.
void copyItem(String pathSrc, String pathDest, int flagACL, String sessionID);
| Arguments | Description |
|---|---|
| String pathSrc | Specifies the current path to the object in the catalog. |
| String pathDest | Specifies the location in the catalog where the object should be copied. |
| int flagACL | Specified whether the item is copied with security. 0 indicates that the item is copied without security. 1 indicates that the item is copied with security. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to generate an archive file from the catalog.
DataHandler copyItem2(List[] path, boolean recursive, boolean permissions, boolean timestamps, boolean useMtom, String sessionID);
| Arguments | Description |
|---|---|
| List[] path | Specifies the location in the catalog from which the archive was created. |
| boolean recursive | Specifies whether the child-level folders were included in the archive. |
| boolean permissions | Specified whether the items are copied with security. |
| boolean timestamps | Specifies whether to preserve the items' time stamps were preserved. |
| boolean useMtom | Specifies whether MTOM was used to encode the content returned by the SOAP message. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to create a folder in the catalog.
void createFolder(String path, boolean createIfNotExists, boolean createIntermediateDirs, String sessionID);
| Arguments | Description |
|---|---|
| String path | Specifies the location in the catalog where the folder should be created, including the name of the new folder. |
| boolean createIfNotExists | If set to TRUE, then the folder object is created in the catalog if it does not already exist. If set to FALSE, then the folder object is not recreated if it already exists. |
| boolean createIntermediateDirs | If set to TRUE, then an intermediate directory is created. If set to FALSE, the an intermediate directory is not created. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to create a link to the catalog.
void createLink(String path, String pathTarget, boolean overwriteIfExists, String sessionID);
| Arguments | Description |
|---|---|
| String Path | Specifies the path to the parent object in the catalog. |
| String TargetPath | Specifies the location in the catalog to which the link being created should refer. |
| boolean overwriteIfExists | If set to TRUE, then the link is overwritten if it already exists in the catalog. If set to FALSE, then the link is not overwritten if it already exists in the catalog. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to delete an object from the catalog. To delete a folder, read Section 3.15.19, "removeFolder() Method".
void deleteItem(String path, String sessionID);
| Arguments | Description |
|---|---|
| String path | Specifies the path to the object in the catalog. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to retrieve catalog information for an object.
ItemInfo getItemInfo(String path, boolean resolveLinks, String sessionID);
| Arguments | Description |
|---|---|
| String path | Specifies the path to the object in the catalog. |
| boolean resolveLinks | If set to TRUE and the path in the catalog refers to a link, then Oracle Business Intelligence retrieves information for the object pointed to by the link. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Returns catalog information for an object in an ItemInfo structure. For more information, see Section 2.21, "ItemInfo Structure".
Use this method to retrieve the maintenance mode status.
Boolean getMaintenanceMode(String sessionID);
| Arguments | Description |
|---|---|
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Returns true or false value indicating current maintenance mode status. For more information, see Section 3.15.15, "maintenanceMode() Method".
Use this method to retrieve the supported categories.
Use this method to retrieve a list of all creatable objects.
Use this method to retrieve a list of all supported catalog object types.
Use this method to retrieve the collection of child sub-items for an object in the catalog.
List[] getSubItems(String path, String mask, boolean resolveLinks, GetSubItemsParams options, String sessionID);
| Arguments | Description |
|---|---|
| String path | Specifies the path to the parent object in the catalog. |
| String mask | Specifies a mask that indicates the child subitems to retrieve. The mask character is an asterisk (*). To retrieve all child subitems, use a single asterisk. |
| boolean resolveLinks | If set to TRUE and the path in the catalog refers to a link, then information is retrieved for the child subitems of the object pointed to by the link. |
| GetSubItemsParams options | Optional. Specifies parameters to supply to the GetSubItemsParams structure. For information about the GetSubItemsParams structure, see Section 2.20, "GetSubItemsParams Structure". |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Returns a collection of child subitems in an ItemInfo structure. For more information, see Section 2.21, "ItemInfo Structure".
Use this method to retrieve the home directory path of a user.
String(String user name, String sessionID);
| Arguments | Description |
|---|---|
| String user name | Specifies the name of the user |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to lock the catalog during maintenance.
void maintenanceMode(boolean flag, String sessionID);
| Arguments | Description |
|---|---|
| boolean flag | Set to TRUE if the catalog is locked. |
| String sessionID) | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to move an object in the catalog to a different location in the catalog.
void moveItem(String pathSrc, String pathDest, int flagACL, String sessionID);
| Arguments | Description |
|---|---|
| String pathSrc | Specifies the current path to the object in the catalog. |
| String pathDest | Specifies the location in the catalog where the object should be moved. |
| int flagACL | Specified whether the item is moved with security. 0 indicates that the item is moved without security. 1 indicates that the item is moved with security. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to paste the copied items.
void pasteItem2(Binary stream DataHandler archive, String replacePath, int flagACL, int flagOverwrite, String sessionID);
| Arguments | Description |
|---|---|
| Binary stream DataHandler archive | Specifies the returned content of the item as string or bytes. What you specify in this field is determined by the readObjects method. |
| String replacePath | Specifies the location to paste the copied item. |
| int flagACL | Specified whether the item is pasted with security. 0 indicates that the item is pasted without security. 1 indicates that the item is pasted without security. |
| int flagOverwrite | Specifies whether the pasted item overwrites existing item. 0 indicates replace all, 1 indicates replace old, 2 indicates replace none, and 3 indicates force replace. |
| int flagReplaceReferences | Specifies whether to replace the path references in the xml objects. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to read an object from the catalog and return a CatalogObject structure.
List[] readObjects(List[] paths, boolean resolveLinks, ErrorDetailsLevel errorMode, ReadObjectsReturnOptions returnOptions, String sessionID);
| Arguments | Description |
|---|---|
| List[] paths | Specifies the location of the object in the catalog. |
| boolean resolveLinks | If set to TRUE and the path in the catalog refers to a link, then the object is written to the location pointed to by the link. |
| ErrorDetailsLevel errorMode | Specifies the amount of error information in the errorInfo field in the CatalogObjects structure. For more information, see Section 2.12, "CatalogObject Structure". |
| ReadObjectsReturnOptions returnOptions | Specifies a list of valid values. For more information, see "ReadObjectsReturnOptions Enumeration". |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Returns an array of "CatalogObject Structure" Objects.
Note:
If a read operation fails for a catalog object (for example, due to an invalid path or insufficient privileges), the errorInfo field for that object contains a description of the error.Use this method to delete a folder and its contents from the catalog. To delete an object other than a folder and its contents, see Section 3.15.7, "deleteItem() Method".
void removeFolder(String path, boolean recursive, String sessionID);
| Arguments | Description |
|---|---|
| String path | Specifies the path to the folder in the catalog. |
| boolean recursive | If set to TRUE, then remove the specified folder and its contents. If set to FALSE, then only remove the specified folder if it is empty, otherwise display an exception message. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to set attribute flags for a specified catalog item.
void setItemAttributes (List[] path, int value, int valueOff, boolean recursive, String sessionID);
| Arguments | Description |
|---|---|
| List[] path | Specifies the path to the folder in the catalog. |
| int value | Specifies which attributes is added. Specifies a combination of the following flags:
1 = read only 2 = archive 4 = hidden 8 = system |
| int valueOff | Specifies which attributes is removed. See the above int value cell for flags. |
| boolean recursive | Specifies whether to set the properties of items in sub-directories. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to set a property for an object in the catalog.
void setItemProperty(List[] path, List[] name, List[] value, boolean recursive, String sessionID);
| Arguments | Description |
|---|---|
| List[] path | Specifies the path to the object in the catalog. |
| List[] name | Specifies the name of the property to set. |
| List[] value | Specifies the new setting for the property. |
| boolean recursive | Specifies whether to set the properties of items in sub-directories. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to take ownership of the specified item.
void setOwnership(List[]path, Account owner, boolean recursive, String sessionID);
| Arguments | Description |
|---|---|
| List[] path | Specifies the location in the catalog of the object to take ownership. |
| Account owner | Specifies the account to assign as owner. |
| boolean recursive | If set to TRUE, then apply this action to the specified folder and its contents. If set to FALSE, then only apply this action to the specified folder if it is empty, otherwise display an exception message. |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to update the Access Control List for an item in the catalog.
void updateCatalogItemACL(List[] path, ACL acl, UpdateCatalogItemACLParams options, String sessionID);
| Fields | Description |
|---|---|
| List[] path | Specifies the path to the object in the catalog. |
| ACL acl | Specifies the Access Control List. For more information, see Section 2.3, "ACL Structure". |
| UpdateCatalogItemACLParams options | Specifies additional parameters. For more information, see Section 2.62, "UpdateCatalogItemACLParams Structure". |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this method to write an array of objects to the catalog.
List[] writeObjects(List[] catalogObjects, boolean allowOverwrite, boolean createIntermediateDirs, ErrorDetailsLevel errorMode, String sessionID);
| Argument | Description |
|---|---|
| List [] catalogObjects | Specifies the objects to write to the catalog, supplied in the CatalogObject structure. For information about the CatalogObject structure, see Section 2.12, "CatalogObject Structure".
All fields of object.itemInfo are ignored, except for the array of item properties, which are applied to the object. The signature of the resulting document is always COXmlDocument1. |
| boolean allowOverwrite | If set to TRUE, then if the object already exists in the catalog, it is overwritten. If set to FALSE, then if the object already exists in the catalog, it is not overwritten. |
| boolean createIntermediateDirs | If set to TRUE and the path in the catalog refers to a link, then the object is written to the location pointed to by the link. |
| ErrorDetailsLevel errorMode | Specifies the amount of error information in the errorInfo field in the "CatalogObject Structure". |
| String sessionID | Specifies the session ID, which is usually returned by the logon method. If the SOAP client engine can handle HTTP cookies, you can omit the session ID or set it to null. |
Use this service to retrieve results from Oracle BI EE Presentation Services in XML format. Table 3-22 shows the supported enumeration and methods.
Table 3-22 XMLView Service Enumeration and Methods
| Enumeration and Method Name | Description |
|---|---|
|
Specifies a list of valid values. |
|
|
Cancels the current query. |
|
|
Runs a SQL query. |
|
|
Runs an XML query. |
|
|
Returns the next page of data rows. |
|
|
Returns a filter XML structure containing only the analysis' columns with a prompted filter. |
|
|
Returns an upgraded version of the requested object. |
This enumeration specifies a list of valid values for the executeSQLQuery() Method and executeXMLQuery() Method. For example, you might want to return data rows and metadata, or data rows only. Table 3-23 lists the values in this enumeration.
Note:
Only one of the values in XMLQueryOutputFormat can be selected.Table 3-23 XMLQueryOutputFormat Enumeration Values
| Values | Description |
|---|---|
|
String SAWRowsetData |
Specifies that the query returns only data rows. |
|
String SAWRowsetSchema |
Specifies that the query returns only metadata. |
|
String SAWRowsetSchemaAndData |
Specifies that the query returns both metadata and data rows. |
Use this method to cancel a query and clean up resources associated with the query. This method should only be used if the query row set is not scrolled to the last row in the data set returned.
Note:
If you use this method when the query row set is scrolled to the last row in the data set returned, query data is cleaned up during the last fetchNext method invocation.Use this method to execute a SQL query and return the results of the query.
Note:
If the results returned exceed one page, you need to use the fetchNext() Method to return the next page of rows.QueryResults executeSQLQuery(String sql, XMLQueryOutputFormat outputFormat, XMLQueryExecutionOptions executionOptions, String sessionID);
| Argument | Description |
|---|---|
| String sql | Specifies the string of SQL code to execute. |
| XMLQueryOutputFormat outputFormat | Specifies the output format (for more information, see Section 2.65, "XMLQueryExecutionOptions Structure"). |
| XMLQueryExecutionOptions executionOptions | Specifies the query execution options (for more information, see Section 2.65, "XMLQueryExecutionOptions Structure"). |
| String sessionID | Specifies the unique ID of the session. |
Returns the results of the query as one or more rows of data in a QueryResults structure (for more information, see Section 2.41, "QueryResults Structure").
Use this method to execute an XML query and return the results of the query.
Note:
If the results returned exceed one page, you need to use the fetchNext() Method to return the next page of rows.QueryResults executeXMLQuery(ReportRef report, XMLQueryOutputFormat outputFormat, XMLQueryExecutionOptions executionOptions, ReportParams reportParams, String sessionID);
| Argument | Description |
|---|---|
| ReportRef reportRef | Specifies the analysis definition, supplied in the ReportRef common structure. |
| XMLQueryOutputFormat outputFormat | Specifies the output format (for more information, see Section 2.65, "XMLQueryExecutionOptions Structure"). |
| XMLQueryExecutionOptions executionOptions | Specifies the query execution options (for more information, see Section 2.65, "XMLQueryExecutionOptions Structure"). |
| ReportParams reportParams | Optional. Specifies the filters or variables to apply to the analysis before execution, supplied in the ReportParams common structure. For information about the ReportParams structure, see Section 2.47, "ReportParams Structure". |
| String sessionID | Specifies the unique ID of the session. |
Returns the results of the query as one or more rows of data in a QueryResults structure (for more information, see Section 2.41, "QueryResults Structure").
Use this method to return the next page of rows retrieved by a query.
Note:
The page returned might contain zero rows. If the finished flag is not set, the remaining rows might not be available immediately.QueryResults fetchNext(String queryID, String sessionID);
| Argument | Description |
|---|---|
| String queryID | Specifies the unique ID of the query, which is returned in the QueryResults object. |
| String sessionID | Specifies the unique ID of the session. |
Returns the next page of query results as one or more rows of data in a QueryResults structure (for more information, see Section 2.41, "QueryResults Structure").
Use this method to retrieve a saved analysis' prompted columns or the prompted columns from an analysis' xml definition. Note that to create an analysis with a prompted column, you must assign the isPrompted operator to it.
Use this method to upgrade Oracle BI EE objects that reside outside of the Presentation Services catalog. This method upgrades object from Oracle BI EE 10g to Oracle BI EE 11g. Use this method primarily for Oracle BI Add-in for Microsoft Office to upgrade the analyses that were saved within Oracle BI Office and not to the catalog. You should only use this method if you want to upgrade the objects in your Oracle BI Office catalog.
Note that if you use methods like executeXmlQuery and use the ReportRef argument to pass an Oracle BI EE 10g report definition, that report is upgraded before the query is run.