How To Fix RS_HCPR_MODEL015 - Temporal join: No Union allowed

RS_HCPR_MODEL015 - Overview

• Message type: E = Error

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

• Message number: 015

• Message text: Temporal join: No Union allowed

What causes this issue?

The HANA CompositeProvider contains a UNION node and at least one JOIN
node. At least one joined PartProvider is time-dependent too.
If there are time-dependent PartProviders in a JOIN node<(>,<)> it is
not possible to have a UNION node as well.
Time-dependent joins are only possible in a join-only scenario, not in a
mixed scenario.

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?

Delete the UNION node
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

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 RS_HCPR_MODEL015 - Temporal join: No Union allowed ?

  The SAP error message RS_HCPR_MODEL015 with the description "Temporal join: No Union 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 the data model is structured, specifically regarding the use of unions in conjunction with temporal joins.
  
  Cause:
  The error arises when you attempt to use a union operation in a data model that also includes a temporal join. Temporal joins are used to combine data based on time-related conditions, and they have specific requirements and limitations. In this case, the system does not allow unions to be used in conjunction with temporal joins, which leads to the error message.
  
  Solution:
  To resolve this error, you can consider the following approaches:
  
  
  Review the Data Model: Check the structure of your data model to identify where the union is being applied. Ensure that