Calling BI Services From External Applications

Did you know that you can get your Fusion Applications reports and analytics data delivered direct to your external applications? It's done using the built-in Oracle OBIEE web services. So to expand on the section in the Getting Started with BI post, let's take a brief look at the features, both of which are available to both on-premises and Oracle Cloud deployments.

BI Analytics

Fusion Applications contains thousands of embedded analytics that give end users the information they need to take effective action, often known as managing-by-exception. As such this important data can be useful in other systems, such as corporate dashboards, intranet portals, or related integrated systems. Analytics are also often visual and as such there is support for return types of XML and HTML. As well as running existing reports, the API also supports scheduling, manipulating the BI Catalog, and even running ad-hoc SQL as a report. You will find the WSDL that describes the services available at the following URL: http://[YourBIserver]/analytics-ws/saw.dll/wsdl/v7 and take a look at the following embedded overview video (here).



BI Publisher

BI Publisher reports are often required for official documentation and as such making them available to other processes and systems may be a very appealing option to many organizations. The separate PI Publisher API supports a similarly broad selection of features through its services, including executing and scheduling existing reports and options for managing the complete catalog. You will find the WSDL that describes the BI Publisher services available at the following URL: https://[yourBIserver]/xmlpserver/services/PublicReportService?WSDL and take a look at the following embedded overview video here.


Resources

Comments:

HI Richard,

Nice Article!!

i have one question in relation to this, so can we embedd BI analysis in our External Application? is this possible?

Posted by apoorv Jain on July 01, 2014 at 05:18 AM PDT #

Hi Apoorv
Yes, you should be able to get the XML or HTML equivalent which you can manipulate into your external application. Take a look at the API's in the integrators guide (linked above) for more details on the options.
Hope this helps,
Richard

Posted by Richard Bingham on July 01, 2014 at 06:06 AM PDT #

Hi Richard,

This is great information.

It would be great if you can share how we can pass variables or input to an analysis as an API request and pull report based on the input. For eg create a report which accepts date as input and the API will return all Activities created after that date.

I really appreciate your inputs on this.

Thanks,
Ajmal

Posted by guest on April 13, 2016 at 09:19 PM PDT #

Hi Ajmal
You can build an analysis to include parameters which you can then use in your report logic. To do this you'll have to do it in the BI Authoring interface - click on the book (browse catalog) icon under the "Report and Analytics" navigator link. From here create a new Analysis. I recommend using a Subject Area when possible. Add the columns you want to see on the report layout first. Then you select the PROMPTS tab and create your parameter(s). You have lots of options here.
Now you have a BI report you can run. If you wish to run this as a web service API call, then the parameters can be put into the XML <reportParams> element.

Read more about the BI web services here in our simple whitepaper here: https://blogs.oracle.com/fadevrel/entry/the_bi_web_services_explained

Kind regards
Richard

Posted by Richard Bingham on April 18, 2016 at 05:39 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Follow us on twitter Fusion Applications Extensibility, Customizations and Integration forum Fusion Applications Dev Relations YouTube Channel
This blog offers news, tips and information for developers building extensions, customizations and integrations for Oracle Fusion Applications.

Search

Categories
Archives
« June 2016
SunMonTueWedThuFriSat
   
1
3
4
5
8
9
10
11
12
14
16
17
18
19
23
24
25
26
27
28
29
30
  
       
Today