Skip to Content
avatar image
Former Member

HANA SQL Issues

Hi All

I'm trying to implement the same logic in HANA

https://stackoverflow.com/questions/43405295/time-dependent-queries

1) When i try the sql its issuing an error message saying that e1 startdate is not in group by clause -- i'm talking about the left outer join sql query

2) How do i implement this in graphical calculation view with non equi joins like e.startdate > e1.startdate etc

Thanks in Adv

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 14, 2017 at 03:25 PM
    -1

    Hello,

    You should use script view instead of graphic view
    Example tutorial for SQL window functions:

    https://www.youtube.com/watch?v=e4TpAIY97hg

    https://blogs.sap.com/2014/10/04/window-function-vs-self-join-in-sap-hana/


    Regards,
    Mateusz.
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Florian, you are right. My answer is more appropriate to SAP BW on HANA where you need another transport path for table functions.

      Best regards,
      Mateusz.