Skip to Content

SAP HANA Parent-Child Hierarchy SQL Expression Parameter

Mar 13, 2017 at 12:12 AM


avatar image
Former Member


I have a large org structure that I have made into a Parent-Child Hierarchy in a Calculation View.

I have also enabled Hierarchies for SQL access as per this blog

In this blog article the author mentions the Hierarchy Expression Parameter that can be used to leverage hierarchy-specific expressions in SQL queries against calculation views.

I am having trouble finding any documentation on how to use this expression parameter. I can successfully query via the Node Column but I also need to query using the Expression Parameter.

Can anyone point me to some documentation or give me some clues as to how this expression parameter can be used in a query?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers