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