SAP Knowledge Base Article - Preview

3478436 - 'Inactive hierarchy' error in oData query

Symptom

Some oData services are throwing an error, when testing them in transaction /n/IWFND/GW_CLIENT:

'Hierarchy inactive but property *PROPERTYNAME_M* requested'

PROPERTYNAME has hierarchy activated for it.

The oData request looks like this (simplified example):

'sap/opu/odata/sap/SERVICENAME/QUERYNAME(mandatory variables)/Results?$select=...PROPERTYNAME_M...'


Read more...

Environment

  • SAP BW/4HANA 1.0
  • SAP BW/4HANA 2.0
  • SAP BW/4HANA 3.0 (2021)
  • SAP BW/4HANA 4.0 (2023)

Product

SAP Analytics Cloud 1.0 ; SAP BW/4HANA 1.0 ; SAP BW/4HANA 2.0 ; SAP BW/4HANA 2021 ; SAP BW/4HANA 2023 ; SAP BW/4HANA Cloud all versions ; SAP S/4HANA 1709 ; SAP S/4HANA 1809 ; SAP S/4HANA 1909 ; SAP S/4HANA 2020 ; SAP S/4HANA 2021 ; SAP S/4HANA 2022 ; SAP S/4HANA 2023 ; SAP S/4HANA 2025 ; SAP S/4HANA Cloud Public Edition all versions

Keywords

hierarchy inactive, Hierarchy inactive but property requested, _NodeID, NodeID, Inactive hierarchy error in oData query, oData error, oData, $select, oData parameters, /n/IWFND/GW_CLIENT , KBA , BW4-AE-API-ODAT , OData , BW-BEX-OT-BICS-EQ , oDATA Query / (Easy Query) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.