cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot select root node of hierarchy via Column View SQL

thilo_kntzele
Participant
0 Kudos

Hi experts,

in our HANA Column View we do not receive any records if we select the root node of a parent-child hierarchy. Can you please tell us how to set up our hierarchy, so it also returns values for the root node?

We have set up a parent-child hierarchy with two root nodes:

If we query the view for PARENT_NODENAME = SER367, we receive two records, as expected:

However, if we query for the nodey column ST_HIER, we do not receive any results:

The node column is defined as follows:

Accepted Solutions (0)

Answers (0)