Skip to Content
avatar image
Former Member

SAP HANA Parent-Child Hierarchy SQL Expression Parameter

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers