How To Fix GK537 - Hierarchy cannot be restricted in dimension &

GK537 - Overview

• Message type: E = Error

• Message class: GK - Messages for SAP Consolidation

• Message number: 537

• Message text: Hierarchy cannot be restricted in dimension &

What causes this issue?

The reconciliation list on higher hierarchy steps is based on the data
generated by the rollup. It is only available if the rollup took place
with substitution of the partner unit.

System Response

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?

Adjust your settings for the dimension &V1& to allow rollup with
substitution of the partner unit, then perform the rollup again.
OR
Start interunit elimination without restricting the hierarchy level.

Error message extract from SAP system. Copyright SAP SE.

GK537 - Details

• The SAP error message GK537, which states "Hierarchy cannot be restricted in dimension &," typically occurs in the context of SAP BW (Business Warehouse) or SAP HANA when you are trying to apply a restriction on a hierarchy that is not allowed in the specified dimension.
  
  Cause:
  
  Hierarchy Type: The hierarchy you are trying to restrict may not support restrictions. Some hierarchies are designed to be used in a certain way and do not allow for filtering or restrictions.
  Dimension Settings: The dimension settings may not allow for the use of hierarchies in the way you are attempting. This could be due to configuration settings in the InfoObject or the way the hierarchy is defined.
  Query Design: If you are working with a query in BEx Query Designer, the query may be incorrectly designed, leading to this error when trying to apply a restriction on a hierarchy.
  
  
  Solution:
  
  Check Hierarchy Definition: Review the hierarchy definition in