How To Fix RS_HCPR_MODEL016 - Temporal join: &1, &2 not allowed

RS_HCPR_MODEL016 - Overview

• Message type: E = Error

• Message class: RS_HCPR_MODEL - Messages related to the HANA Composite Provider Backend

• Message number: 016

• Message text: Temporal join: &1, &2 not allowed

What causes this issue?

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

When a temporal join is used<(>,<)> only the following TLOGO objects are
supported:
ADSO: Advanced DataStore Object
CUBE: InfoCube
IOBJ: InfoObject
ODSO: Classic DataStore Object

How to fix this error?

Remove all unsupported TLOGO objects
Switch off the time-dependency of all joined time-dependent
PartProviders (ScenarioTab, SourceTree)
InfoObjects: Hide time-dependent fields
Advanced/classic DataStore Objects, InfoCubes: Remove time-dependency

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RS_HCPR_MODEL016 - Temporal join: &1, &2 not allowed ?

  The SAP error message RS_HCPR_MODEL016, which states "Temporal join: &1, &2 not allowed," typically occurs in the context of SAP HANA or SAP BW when working with data models that involve temporal joins. This error indicates that there is an issue with the way temporal joins are being defined or used in your data model.
  
  Cause:
  
  
  Incompatible Time Characteristics: The error often arises when the time characteristics of the two tables or data sources being joined are not compatible. For example, one table may have a time dimension defined as a "validity period," while the other may not have a corresponding time dimension.
  
  
  Incorrect Join Type: The join type specified may not be appropriate for the temporal data being used. Temporal joins require specific conditions to be met regarding the time attributes.
  
  
  Missing Time Attributes: One or both of the tables involved in the join may be missing the necessary time attributes that are