Skip to Content

Cannot select root node of hierarchy via Column View SQL

Dec 15, 2017 at 03:28 PM


avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers