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

SAP Error Message - Details

• 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 in the Query Designer.
  Ensure that the InfoObject that is required for the "Number of Records" calculation is included in the drilldown. This is typically a characteristic that can be used to group or filter the data.
  
  
  
  Add Required InfoObject:
  
  If the required InfoObject is not present, add it to the query. This could be a characteristic that is relevant to the data being analyzed.
  
  
  
  Review Aggregation Settings:
  
  Check the aggregation settings for the InfoObjects in the query. Ensure that they are set up correctly to allow for the calculation of the number of records.
  
  
  
  Test the Query:
  
  After making changes, execute the query again to see if the error persists. 
  
  
  
  Consult Documentation:
  
  Refer to SAP documentation or help resources for specific details on the InfoObjects and their relationships in your data model.
  
  
  
  Seek Help from SAP Support:
  
  If the issue persists after trying the above solutions, consider reaching out to SAP support for further assistance.
  
  
  
  Related Information:
  
  InfoObjects: These are the building blocks of SAP BW data models, representing characteristics and key figures.
  Drilldown: This refers to the ability to navigate through data hierarchies in reports, allowing users to analyze data at different levels of detail.
  Number of Records: This is a common metric used in reporting to show how many entries meet certain criteria.
  
  By ensuring that the necessary InfoObjects are included in your query and that the query is designed correctly, you should be able to resolve the RSDRV_VPROHANA036 error.