SAP Knowledge Base Article - Public

2723762 - Error when building Odata Queries: TOO_MANY_DRILL_DOWN_OBJECTS

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

  1. Go to the Business Analytics work center.
  2. Go to the Design Report view.
  3. Find the report you want to build Odata Queries.
  4. Click the button Build Odata Queries.
  5. Click tab Build Odata Queries.
  6. Tick the box Count on the top right and click tab Generate Data Query.
  7. 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.

See Also

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

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