Skip to Content
0
Apr 25, 2019 at 09:42 AM

SAP HANA1SP12: how to implement NON EQUI-JOIN(Temporal join) on calculation view?

740 Views

SAP HANA Version: hana1sp12

There have a SQL statement is:

JOIN ON CREATE_DATE >= MODIFY_DATE

Because I have a lot of nodes in the old calculation view, and I want to implement new nodes will use non equi-join >= on the calculation view. After my search on the Internet, I saw people suggested to use 'temporal join'. But it is disable on calculation view at my hana1sp12 version. Then, I find some people have same issue(https://answers.sap.com/questions/133294/temporal-joins-option-is-disabled-in-hana-calculat.html). But no one know the exactly solution or answer about this issue.

Does someone could give suggestions for me if I need to implement in calculation view, or do I have work around methods to implement on calculation view?

Thank you.

J.K