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

SAP Error Message - Details

• 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.

Smart SAP Assistant

• What is the cause and solution for SAP error message GK537 - Hierarchy cannot be restricted in dimension & ?

  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 the InfoObject. Ensure that it is set up correctly and that it allows for restrictions if that is your intention.
  Modify Query: If you are using BEx Query Designer, check the query design. Ensure that you are not trying to restrict a hierarchy in a way that is not supported. You may need to adjust the query to use a different approach for filtering.
  Use Alternative Filters: Instead of restricting the hierarchy, consider using other filtering options available in the query or report that do not involve direct restrictions on the hierarchy.
  Consult Documentation: Refer to SAP documentation or help resources for specific details on the hierarchy and dimension you are working with. This can provide insights into what is permissible and what is not.
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may address this specific error or provide additional context on hierarchy restrictions.
  SAP Community: Engage with the SAP Community forums where other users may have encountered similar issues and can provide insights or solutions.
  Training and Documentation: If you are new to SAP BW or HANA, consider reviewing training materials or documentation that cover the use of hierarchies and dimensions in queries.
  
  If the issue persists after trying the above solutions, it may be beneficial to consult with an SAP BW or HANA expert or your organization's SAP support team for further assistance.