Defining a recursive view in SAP HANA

[former_member292197]

Hi All,

Currently SAP HANA does not support defining recursive views as already mentioned in Tals discussion as per the following link:

I would like to ask again if this limitation is still exist in latest SAP HANA version or not?

Some background:

In our MDM product we can create a hierarchy tables which organizes information in a hierarchy where each record is related to a parent record and may also be related to sibling records and/or child records.

On other hands, MDM product generates database views that are saved as database queries representing MDM data. Currently HANA limitation prevents creating a database view on top of hierarchy database tables.

Best regards,

Ahmad

[lbreddemann]

Hi Ahmad,

just as I mentioned in there is a feature available in SAP HANA (column view type hierarchy aka hierarchy views) that is used (SAP-) internally.

AFAIK there are some ideas to make this available via SQL, but I don't know when or how this functionality will make it into the standard product.

the core HANA PM might be able to answer that.

Until then, you might be better off contacting SAP HANA development about possibly using hierarchy views for your development.

- Lars

[ruediger_karl]

Hi,

Actually, hierarchy views are runtime objects in HANA. They are used by HANA whenever you define parent-child or level-hierarchies in HANA views with the HANA modeler. Modeled hierarchies are meanwhile widely used by our HANA customers and our own business suite applications.

Although, you can see the runtime objects in the HANA repository, we do not expose and support the SQL extensions officially. They represent an internal interface that can be changed by SAP for any reasons. However, we work on an official SQL-interface for native HANA hierarchies, but this is not to be expected in 2015. 

Regards, Ruediger