How to use the Odata.ReportExecute() method from the Platinum Engineering namespace

[Hanumath]

Hi Experts,

I am trying to use the above method and library from the Platinum Engineering namespace to read the report data using the ODATA services.

Can anyone in the network help me on this to execute the report using the ODATA url and retrieve the data from the cloud application studio?

It would be a great help in having this information and samples/blog/old threads on this.

Regards

Hanu K

[Hanumath]

Any help on this will be really appreciated 🙂

[YatseaLi]

Hi Hanumath,

You take it right.

For passing the query parameter and selection parameter, you can check OData 2.0 document. https://www.odata.org/documentation/odata-version-2-0/uri-conventions/

There are also a few samples in the Knut's blog mentioned above.
Get service confirmations for contract CC1001:

/sap/byd/odata/cc_home_analytics.svc/RPZABCDEF12345678ABCDEFQueryResults?$inlinecount=allpages&$select=FCISL_ACT_QTY_B,FCACCO_IAV_INV_QTY_BU,FCACCO_ITV_REQU_QTY_BU,FCZ0COUNT,CIBR_CUCO_ID,TIBR_CUCO_ID,CIBR_CUCO_I_ID,TIBR_CUCO_I_ID,CCCCO_DPY_MAINBUYERPTY,TCCCO_DPY_MAINBUYERPTY,CACCO_ITM_CREATIONDATE,CACCO_ITM_LASTCHANGEDATE&$filter=CIBR_CUCO_ID eq ‘CC1001’

Kind Regards, Yatsea

[Hanumath]

Thanks, Yatsea. I will try this and let you know.

Regards

Hanu K

[YatseaLi]

Hi Hanumath,

Please refer to this blog about OData for SAP Business ByDesign Analytics, which show you how to access the datasource, report of ByD through OData.

https://blogs.sap.com/2015/03/10/odata-for-sap-business-bydesign-analytics/

Then you will just need an outbound http call to consume it like any other OData source.

It is not recommended any Platinum Engineering function, which is no official interface for external.

Kind Regards, Yatsea

[Hanumath]

Hi Yatsea,

Thanks for your reply. If I understood this you are asking me to use the ODATA Reports API as any other REST API's consumption in ByDesign?

Considering the ODATA API as external REST service and consume it in ByDesign using the external web service integration and read the data. But how I can pass the query parameters and selection parameters to the API is confusing.

Any help on this would be appreciated.

Regards

Hanu K