topic Re: SAP HANA - SQL - HIERARCHY Function (Hierarchy Generator) in Application Development and Automation Discussions

SAP HANA - SQL - HIERARCHY Function (Hierarchy Generator)

LuisBenavidesA — Fri, 30 Aug 2019 11:08:35 GMT

Dear Expert,

I am try to list the hierarchy information thought SQL - HIERARCHY Function into SQL editor. But I have gotten empty outcome.

The SQL statement is

SELECT * FROM HIERARCHY ( SOURCE ( SELECT "NODEID" AS "NODE_ID", "PARENTID" AS "PARENT_ID", 0 AS "TYPE" FROM "SAPABAP1"."/B28/H*****" WHERE HIEID = '*****') );

The Log of Visualize Plan attached.

visualizeplan.png

Hana system version: 2.00.034

Thanks advanced for your support

Re: SAP HANA - SQL - HIERARCHY Function (Hierarchy Generator)

former_member614035 — Mon, 27 Apr 2020 11:10:21 GMT

Hi, even I too faced the same problem. Is there any solution yet. Thanks advanced for your support

Re: SAP HANA - SQL - HIERARCHY Function (Hierarchy Generator)

former_member614035 — Mon, 27 Apr 2020 11:55:46 GMT

Hi,

Even I too face the same problem. Is there any solution?

Re: SAP HANA - SQL - HIERARCHY Function (Hierarchy Generator)

former_member321499 — Tue, 07 Feb 2023 15:39:30 GMT

Hi,

This issue occurs because ROOT node must have 'null' in PARENT_ID.

You should add the following expression:

case when "PARENTID" = 0 then null else "PARENTID" end AS "PARENT_ID"