How To Fix RSR_PE059 - Cube &1 contains CR &2 of type "hierarchy". Cannot run scenario in PAK.

SAP Error Message - Details

• Message type: E = Error

• Message class: RSR_PE - TREX Planning Engine

• Message number: 059

• Message text: Cube &1 contains CR &2 of type "hierarchy". Cannot run scenario in PAK.

What causes this issue?

InfoProvider &1 contains character relationship &2 of type "hierarchy".
This prevents the whole scenario from running as SAP HANA-optimized in
PAK.

System Response

As described in SAP Note 1637199, this characteristic relationship makes
the whole scenario run using classic IP-based planning<(>,<)> rather
than as SAP HANA-optimized with PAK. The performance of planning actions
like executing sequences is the same as in classic BW-IP.

How to fix this error?

Remove or deactivate character relationship &2 using transaction RSPLAN
<(>,<)> in order to run the scenario as SAP HANA-optimized.

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 RSR_PE059 - Cube &1 contains CR &2 of type "hierarchy". Cannot run scenario in PAK. ?

  The SAP error message RSR_PE059 indicates that there is a problem with a data cube in the context of the SAP BW (Business Warehouse) system, specifically when using the Planning Application Kit (PAK). The error message states that the cube contains a characteristic (CR) of type "hierarchy," which is causing issues when trying to run a planning scenario.
  Cause:
  
  Hierarchy Characteristics: The cube contains characteristics that are defined as hierarchies. In SAP BW, certain planning scenarios may not support the use of hierarchy characteristics directly.
  Planning Function Restrictions: The planning function or the scenario you are trying to execute may not be designed to handle data that includes hierarchical structures.
  Data Model Issues: There may be inconsistencies or misconfigurations in the data model that prevent the scenario from executing properly.
  
  Solution:
  
  Check Planning Scenario: Review the planning scenario you are trying to execute. Ensure that it is compatible with the characteristics defined in your cube. If the scenario does not support hierarchies, consider modifying it or using a different scenario.
  Remove Hierarchy Characteristics: If possible, consider removing the hierarchy characteristics from the cube or using a different characteristic that does not involve hierarchies for the planning scenario.
  Modify Data Model: If the hierarchy is essential, you may need to adjust your data model or create a new cube that does not include hierarchy characteristics for the specific planning scenario.
  Consult Documentation: Refer to SAP documentation or notes related to the Planning Application Kit and the specific planning functions you are using. There may be specific guidelines or limitations regarding the use of hierarchies.
  SAP Support: If the issue persists, consider reaching out to SAP support for assistance. They may provide insights or patches that address the issue.
  
  Related Information:
  
  SAP BW Documentation: Review the official SAP BW documentation for details on planning scenarios and the use of hierarchies.
  SAP Notes: Check for any relevant SAP Notes that may address this specific error or provide additional context.
  Community Forums: Engage with SAP community forums or user groups where similar issues may have been discussed, and solutions shared.
  
  By following these steps, you should be able to identify the root cause of the error and implement a suitable solution.