How To Fix RSODP059 - Intervals are not supported in hierarchies

SAP Error Message - Details

• Message type: E = Error

• Message class: RSODP - Operational Data Provider: Messages

• Message number: 059

• Message text: Intervals are not supported in hierarchies

What causes this issue?

An hierarchy ODP with an interval segment can only be considered if the
corresponding text and attribute ODPs do not have any mandatory
selection fields.

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?

Modify the text and attribute extractors accordingly or omit the
interval segment.

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 RSODP059 - Intervals are not supported in hierarchies ?

  The SAP error message RSODP059, which states "Intervals are not supported in hierarchies," typically occurs in the context of SAP BW (Business Warehouse) or SAP BW/4HANA when working with queries that involve hierarchies and interval selections.
  Cause:
  This error arises when you attempt to use interval selections (e.g., ranges like "greater than," "less than," or "between") on characteristics that are part of a hierarchy. In SAP BW, hierarchies are structured data representations that allow for the organization of data in a parent-child relationship. However, interval selections are not compatible with the hierarchical structure because they require a linear representation of data.
  Solution:
  To resolve this error, you can consider the following approaches:
  
  
  Change Selection Criteria:
  
  Instead of using interval selections, use single value selections or specific member selections that are compatible with the hierarchy. For example, select individual nodes or members from the hierarchy rather than specifying a range.
  
  
  
  Modify the Query:
  
  If you are working with a query in BEx Query Designer, review the query design and ensure that you are not applying interval filters on characteristics that are part of a hierarchy.
  
  
  
  Use Alternative Characteristics:
  
  If applicable, consider using a different characteristic that does not have a hierarchy associated with it for your interval selections.
  
  
  
  Check Hierarchy Settings:
  
  Review the hierarchy settings in the InfoObject to ensure that they are correctly defined and that you are not inadvertently applying filters that are incompatible with the hierarchy.
  
  
  
  Consult Documentation:
  
  Refer to SAP documentation or help resources for more detailed guidance on working with hierarchies and intervals in your specific version of SAP BW.
  
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may address this specific error or provide additional context or fixes.
  SAP Community: Engage with the SAP Community forums to see if other users have encountered similar issues and what solutions they have found.
  Training and Documentation: Consider reviewing training materials or documentation related to SAP BW query design and hierarchy management to better understand the limitations and best practices.
  
  By following these steps, you should be able to resolve the RSODP059 error and successfully work with your data in SAP BW.