Skip to Content
0

SAP HANA Parent-Child Hierarchy SQL Expression Parameter

Mar 13, 2017 at 12:12 AM

289

avatar image

Hi.

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 https://blogs.sap.com/2015/07/09/new-hierarchy-sql-enablement-with-calculation-views-in-sap-hana-10-sps-10/

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