SAP HANA - SQL - HIERARCHY Function (Hierarchy Generator)

[LuisBenavidesA]

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

[LuisBenavidesA]

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

[former_member614035]

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

[former_member614035]

Hi,

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

[former_member321499]

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"