How To Fix RSPLS_CR003 - Source characteristic value '&1' is not included in hierarchy '&2'

SAP Error Message - Details

• Message type: E = Error

• Message class: RSPLS_CR - Messages on Characteristic Relationships/Data Slices

• Message number: 003

• Message text: Source characteristic value '&1' is not included in hierarchy '&2'

What causes this issue?

You are using a hierarchy with technical name '&V2&' in the
characteristic relationships for InfoCube '&V4&'. You want to perform
a derivation for characteristic '&V3&' with characteristic value '&V1&'.
However, the characteristic value is not included in the hierarchy.

System Response

The system cannot perform derivation.

How to fix this error?

If necessary, extend the hierarchy to include this value.

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 RSPLS_CR003 - Source characteristic value '&1' is not included in hierarchy '&2' ?

  The SAP error message RSPLS_CR003 indicates that a source characteristic value (represented as &1) is not included in the specified hierarchy (represented as &2). This error typically occurs in the context of SAP BW (Business Warehouse) when working with hierarchies in queries or data models.
  Cause:
  
  Missing Hierarchy Entry: The specific characteristic value you are trying to use is not part of the defined hierarchy. This can happen if the data has been updated or if the hierarchy has been modified without including the new values.
  Incorrect Hierarchy Assignment: The characteristic value may belong to a different hierarchy or may not be assigned to any hierarchy at all.
  Data Load Issues: If the data load process did not include the characteristic value in the hierarchy, it will lead to this error.
  Hierarchy Activation: The hierarchy might not be activated or might be in a state that does not allow it to be used in queries.
  
  Solution:
  
  Check Hierarchy Definition: Verify that the characteristic value is indeed part of the hierarchy. You can do this by navigating to the hierarchy in the SAP BW modeling tools and checking the entries.
  Update Hierarchy: If the characteristic value is missing, you may need to update the hierarchy to include the missing value. This can be done through the hierarchy maintenance transaction (e.g., RSH1 for creating or modifying hierarchies).
  Data Load: Ensure that the data load process includes the characteristic value in the hierarchy. You may need to reprocess the data load or adjust the transformation rules.
  Check Query Design: If you are using a query that references the hierarchy, ensure that the query is correctly designed to use the appropriate hierarchy and that the characteristic values are correctly mapped.
  Hierarchy Activation: If the hierarchy is not activated, activate it to make it available for use in queries.
  
  Related Information:
  
  Transaction Codes: You may use transaction codes like RSH1 (Hierarchy Maintenance) and RSA1 (Data Warehousing Workbench) to manage hierarchies and data models.
  Documentation: Refer to SAP Help documentation for more details on managing hierarchies and troubleshooting common errors in SAP BW.
  SAP Notes: Check for any relevant SAP Notes that may address specific issues related to hierarchies and characteristic values.
  
  By following these steps, you should be able to resolve the RSPLS_CR003 error and ensure that your characteristic values are correctly included in the relevant hierarchies.