How To Fix UPB165 - Only preceding rows of key figure scheme are allowed as reference rows

UPB165 - Overview

• Message type: E = Error

• Message class: UPB - BPS: Balance sheet planning messages

• Message number: 165

• Message text: Only preceding rows of key figure scheme are allowed as reference rows

What causes this issue?

You have entered a row number as a reference row, which is greater than
or equal to the row number of the current row.

System Response

The key figure scheme is inconsistent.

How to fix this error?

Correct your settings on the reference rows.

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message UPB165 - Only preceding rows of key figure scheme are allowed as reference rows ?

  The SAP error message UPB165, which states "Only preceding rows of key figure scheme are allowed as reference rows," typically occurs in the context of SAP Business Planning (BPC) or SAP Integrated Business Planning (IBP) when working with key figure schemes in planning models. This error indicates that there is an issue with how reference rows are defined in relation to the key figure scheme.
  
  Cause:
  The error is caused by attempting to use a reference row that is not positioned correctly within the key figure scheme. In SAP planning models, reference rows are used to derive values based on other rows. However, the system enforces a rule that only allows reference rows to refer to preceding rows in the scheme. If a reference row tries to refer to a row that is not before it in the sequence, this error will be triggered.
  
  Solution:
  To resolve the UPB165 error, you can take the