How to Access OTBI report using Groovy within Oracle Fusion

User_02ANP

How to Access OTBI report using Groovy within Oracle Fusion

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/23993/how-to-access-otbi-report-using-groovy-within-oracle-fusion

Can you please elaborate your requirement?

Thanks.

Sreekanth M, Oracle-Oracle

HI @User_02ANP ,

If you are talking about the BIP Reports , yes it is possible to invoke them from Groovy using SOAP API's. SOAP API's helps to run the report and gives the result and that can can be consumed as per the requirements.

Thanks,

Sreekanth M

User_02ANP

https://community.oracle.com/products/oracleanalytics/discussion/comment/61572#Comment_61572

We have a OTBI analysis report and i want to access it in groovy and fetch/read the analysis rows from groovy

Sreekanth M, Oracle-Oracle

HI @User_02ANP ,

In which module are you trying to use the Report ? Is it for CRM ? If it is a BIP Report yes you will be able to access it using SOAP API's.

Thanks,

Sreekanth M

User_02ANP

its CRM and its not BIP XDO report. it is just otbi analyses report

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/61965#Comment_61965

I don't see a direct way of doing it. You can definitely call BIP reports from groovy with the approach given in below note:

How To Call BIP Report Webservice From App Composer using Groovy Script (Doc ID 2150332.1)

Can you try similar approach for OTBI with webservices mentioned in below notes:

How to include date filter on OTBI report using webservice (Doc ID 2815071.1)

How To Run SAWRowsetSchemaAndData WebService To Retrieve Data From An OTBI Analysis (Doc ID 2814254.1)

Thanks.