Photo by Myriam Jessier on Unsplash

Execute OTBI Analysis using Web Services

Oracle provides web services to invoke and retrieve data from OTBI (Oracle Transactional Business Intelligence) Analysis. Let’s see how in this post.

Web Services

For a complete list of available web services check out Oracle documentation. We will be focusing on two services and 3 methods.

Login and Create Session

Let’s first login and create a session. Use the below code snippet and provide the correct user name and password.

Web Services URL to be used — https://hostname/analytics-ws/saw.dll?SoapImpl=nQSessionService

The return message will have session id field. The session Id will be passed in the executeXMLQuery method call.

Execute Query

You should have the path to the OTBI Analysis. The path should include the analysis name. Make sure to provide the correct host name.

Web Services URL to be used — https://hostname/analytics-ws/saw.dll?SoapImpl=xmlViewService

The return message will have the rows and a query ID that will be needed if you are using the fetchNext method.

Fetch Additional Records

Use the fetchNext method to fetch additional records from the query. Make sure to pass the queryID value from the executeXMLQuery method response. You need to pass the session ID value as well.

Web Services URL to be used — https://hostname/analytics-ws/saw.dll?SoapImpl=xmlViewService

Hopefully this helps you to execute OTBI Analysis using Web Services. If you have questions let me know. You may also check out my post on invoking BI Publisher report using Web Services here.

Happy Learning and experimenting.

Manager Strategic Cloud Services (Oracle Cloud ERP, EPM), Integration Specialist, Big Data, Data Science & Python Enthusiast)

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store