How To Fix RSCV160 - Hierarchy screen & has SUM(FACTOR)=&, but the value must be 1

RSCV160 - Overview

• Message type: E = Error

• Message class: RSCV - Analysis of BW objects (InfoCubes...)

• Message number: 160

• Message text: Hierarchy screen & has SUM(FACTOR)=&, but the value must be 1

What causes this issue?

The sheet enters is in an inconsistent state. For example, sheets can
appear several times in a hierarchy, but in order to execute a query it
is necessary that a sheet is only counted once, both in the sum and
also individually.

System Response

Queries about this hierarchy deliver incorrect results.

How to fix this error?

Start the repair in the initial screen or the program
'RRINCLTAB_REBUILD'.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSCV160 - Hierarchy screen & has SUM(FACTOR)=&, but the value must be 1 ?

  The SAP error message RSCV160 typically occurs in the context of SAP BW (Business Warehouse) when dealing with hierarchies in InfoObjects. This error indicates that the sum of the factors assigned to the nodes in a hierarchy does not equal 1, which is a requirement for certain types of hierarchies, particularly when they are used for planning or allocation purposes.
  
  Cause:
  The error arises when the hierarchy nodes have been assigned factors (weights) that do not sum up to 1. This can happen due to:
  
  Incorrect manual entry of factors for the hierarchy nodes.
  Changes in the hierarchy structure that were not reflected in the factor assignments.
  Data inconsistencies or corruption in the hierarchy definition.
  
  
  Solution:
  To resolve the RSCV160 error, you can follow these steps:
  
  
  Check Hierarchy Definition:
  
  Go to the hierarchy maintenance transaction (e.g., RSH1 for InfoObjects).
  Review the hierarchy structure and ensure that all nodes are correctly defined.
  
  
  
  Verify Factor Assignments:
  
  Check the factors assigned to each node in