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 comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers