How To Fix RSDDTPS_HIER124 - Usage of the deselected hierarchies deleted

SAP Error Message - Details

• Message type: E = Error

• Message class: RSDDTPS_HIER -

• Message number: 124

• Message text: Usage of the deselected hierarchies deleted

Self-Explanatory Message

Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.

To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.

Unfortunately, there isn't any extra information in this error notice.

What else can you do?

First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).

Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.

You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSDDTPS_HIER124 - Usage of the deselected hierarchies deleted ?

  The SAP error message RSDDTPS_HIER124, which states "Usage of the deselected hierarchies deleted," typically occurs in the context of SAP BW (Business Warehouse) when working with InfoObjects and hierarchies. This message indicates that certain hierarchies that were previously selected for use in a query or report have been deselected, leading to their removal from the relevant data model or query definition.
  Cause:
  
  Hierarchy Deselecting: The most common cause of this error is that a user has deselected a hierarchy in the InfoObject settings or in the query designer. This can happen during modifications to the InfoObject or when adjusting the query settings.
  Data Model Changes: Changes in the underlying data model, such as updates to InfoObjects or InfoProviders, can lead to hierarchies being deselected.
  Inconsistent Data: If there are inconsistencies in the data model or if the hierarchy is not properly maintained, it can lead to this error.
  
  Solution:
  
  Review Hierarchy Settings: Go to the InfoObject maintenance and check the hierarchy settings. Ensure that the required hierarchies are selected for the InfoObject in question.
  Update Queries: If you are working with queries, open the query designer and verify that the necessary hierarchies are included in the query definition. Re-add any deselected hierarchies if needed.
  Check Data Model: Review any recent changes made to the data model or InfoProviders. Ensure that all necessary hierarchies are properly defined and active.
  Transport Requests: If the issue arose after a transport request, ensure that all relevant objects were transported correctly and that there are no missing dependencies.
  Rebuild Hierarchies: If the hierarchy is corrupted or not functioning as expected, consider rebuilding the hierarchy from scratch or restoring it from a backup if available.
  
  Related Information:
  
  SAP Notes: Check SAP Notes for any specific notes related to this error message. SAP frequently updates its knowledge base with solutions and workarounds for known issues.
  Documentation: Refer to the SAP BW documentation for detailed information on managing hierarchies and InfoObjects.
  Community Forums: Engage with SAP community forums or user groups where similar issues may have been discussed, and solutions shared.
  
  If the problem persists after trying the above solutions, it may be beneficial to consult with your SAP Basis or BW team for further investigation, as they may have access to logs and additional tools to diagnose the issue.