3327518 - OData Query is Resulting in Zero Results or Limited Data

You are trying to use the standard Odata Query. However, OData request is not retrieving any data or retrieving limited data.

SAP Business ByDesign

You are using the OData request to retrieve the data from standard "Sales Order Volume" report as below:

https://myXXXXXXX.sapbyd.cn/sap/byd/odata/ana_businessanalytics_analytics.svc/RPCRMSLOIB_MQ0001QueryResults?

However, OData request is not retrieving any data or retrieving limited data.

Report execution through OData requests always gets executed only for initial selection, that is, the parameters which are maintained in the report metadata.

If you check in the report "Sales Order Volume", it shows Employee Responsible as "Employee - My User Name" in the browser. Hence the OData request is also not retrieving any data or retrieving limited data.

This is the current system behavior.

To solve this, you have the following options:

1. Either, you can create a copy of the report "Sales Order Volume" and change the selection as required. In the steps 4 and 5, you can change which variables will be used and which default selections are maintained.

2. Alternatively, you can overwrite the initial selection in your OData query. For example, if you would like to run the query

https://myXXXXXXX.sapbyd.cn/sap/byd/odata/ana_businessanalytics_analytics.svc/RPCRMSLOIB_MQ0001QueryResults?

but you would also like to change the variable on "Employee Responsible", you would need to use the field PARA_CRMSLOIB_REP_02.

For example:

https://myXXXXXXX.sapbyd.cn/sap/byd/odata/ana_businessanalytics_analytics.svc/RPCRMSLOIB_MQ0001QueryResults?$filter=(PARA_CRMSLOIB_REP_02 eq 'ABC') (where ABC represents the Employee ID)

This filters on the employee ABC.

Blog: OData for SAP Business ByDesign Analytics

Help document: Retrieving Analytics Data Using OData

OData, Report, Sales Order Volume, Employee Responsible, Zero Results, Limited Data , KBA , SRD-CRM-ORD , Orders & Contracts , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem