How To Fix RSDRV_VPROHANA036 - Another InfoObject has to be in drilldown with "Number of Records"

RSDRV_VPROHANA036 - Overview

• Message type: E = Error

• Message class: RSDRV_VPROHANA - Message Class for VirtualProvider Based on SAP HANA Model

• Message number: 036

• Message text: Another InfoObject has to be in drilldown with "Number of Records"

What causes this issue?

On an InfoObject based on HANA CalculationView it is not allowed to
request only the Keyfigure "Number of Records" (1ROWCOUNT).

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Drilldown a Characteristics or request another Keyfigure.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSDRV_VPROHANA036 - Another InfoObject has to be in drilldown with "Number of Records" ?

  The SAP error message RSDRV_VPROHANA036 typically occurs in the context of SAP BW (Business Warehouse) or SAP HANA when you are trying to execute a query or report that requires a specific configuration for the InfoObjects involved in the drilldown. This error indicates that another InfoObject must be included in the drilldown to provide the "Number of Records" functionality.
  
  Cause:
  The error is usually caused by the following reasons:
  
  Missing InfoObject: The query is designed to show the number of records, but the required InfoObject that provides the context for this calculation is not included in the drilldown.
  Query Design: The query might not be properly designed to support the "Number of Records" feature, which requires certain InfoObjects to be present.
  Aggregation Issues: There may be issues with how the data is aggregated or how the InfoObjects are related in the query.
  
  
  Solution:
  To resolve this error, you can take the following steps:
  
  
  Check Query Design:
  
  Open the query