2723762 - Error when building Odata Queries: TOO_MANY_DRILL_DOWN

Symptom

You build an Odata query but when you launch the query you get an error.

Example:

https://<your system hostname>/sap/byd/odata/ana_businessanalytics_analytics.svc/RP<report ID>QueryResults/$count

You get the following error:

Program error in class CL_RSBOLAP_QV_RESULT_SET method: TOO_MANY_DRILL_DOWN_OBJECTS

Environment

SAP Business ByDesign
SAP Cloud for Customer

Reproducing the Issue

Go to the Business Analytics work center.
Go to the Design Report view.
Find the report you want to build Odata Queries.
Click the button Build Odata Queries.
Click tab Build Odata Queries.
Tick the box Count on the top right and click tab Generate Data Query.
Copy the link to the browser.

You get the following Errors:

Program error in class CL_RSBOLAP_QV_RESULT_SET method: TOO_MANY_DRILL_DOWN_OBJECTS

Cause

The error message is displayed because the report has too many fields (characteristics + key figures). You have either selected a high number of characteristics by using $select, or you have not selected any fields at all which means that the system will try to retrieve all characteristics and key figures.

The report must not have more than 50 fields to work correctly.

Resolution

Select fewer fields to be displayed in the report, by using the $select operator.

You can also make use of the INLINE Count - the number of records will be retrieved.

Keywords

Program error in class CL_RSBOLAP_QV_RESULT_SET method : TOO_MANY_DRILL_DOWN_OBJECTS, Count Odata Queries,AP-RC-ANA, Odata ,error, characteristics,TOO MANY DRILL DOWN , KBA , too many drill down objects , drilldown , AP-RC-ANA-UI , C4C, ByD, Travel: Analytics UI Framework , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions

2723762 - Error when building Odata Queries: TOO_MANY_DRILL_DOWN_OBJECTS