Skip to Content

Cannot select root node of hierarchy via Column View SQL

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:

1.png (65.7 kB)
unbenannt3.png (72.0 kB)
unbenannt2.png (116.8 kB)
unbenannt.png (90.7 kB)
unbenannt4.png (29.8 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.