Can you get data from data model or report (not analysis) thought web service (XmlViewService) ?

maria.stanciu

Summary:

We need to get the data displayed in a data model or report in an web service (for further integrations).

The web service is XmlViewService which allows ExecuteSqlQuery and ExecuteXmlQuery actions.

We have this for an 'Analysis' type but same web service configuration is not working for data model or report .

What needs to be changed so that it works for 'analysis' too? Or how do you get the data to the the web service ?

Thank you.

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Nathan CCC

A OTBI report with a data model uses a different service.

REST API BIP​

https://docs.oracle.com/middleware/bi12214/bip/BIPAP/index.html​

Java API BIP​

https://docs.oracle.com/middleware/12213/bip/BIPJD/toc.htm

maria.stanciu

We use only soap messages

Bhaskar Konar

Hi @maria.stanciu,

Please have a look into the following use case & example which might be useful.

A Practical Introduction to the OTBI and BI Publisher web services - ERPWebTutor

Hope this help.

Cheers,

Praveen Kumar Akkala-Oracle

Hello @maria.stanciu,

Please review the below document which lists out all the available web services in Fusion BI Publisher.

Fusion Application BI Publisher (BIP) : Available Public Webservices in Fusion Applications (Doc ID 2086077.1)

Thanks,

Praveen