2726463 - Fields Not Sorted Using $OrderBy in OData Reports

You have built an OData query to retrieve report data, and you have used the operand OrderBy to sort the fields, however in the report results you can see that the data is not sorted.

For example: You are calling the report Invoice Volume via the following URL:

https://myxxxxxx.sapbydesign.com/sap/byd/odata/ana_businessanalytics_analytics.svc/RPCRMCIVIB_Q0001QueryResults?$select=CIPR_PROD_UUID,CIACBA_PRJ_UUID&$orderby=CDOC_UUID desc

And you would expect that the results are sorted by Invoice ID, in a descending order, however this is not the case.

SAP Business ByDesign

SAP Hybris Cloud for Customer

Odata, report, orderby, sorting, characteristic, ascending, descending, System query options '$orderby' are not allowed in the requested URI , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem