Availability of Oracle Analytical Functional in HANA

[Former Member]

Hi Experts,

We have only few oracle analytical functions available in HANA like RANK,DENSE_RANK etc as window functions. we have lot of more in oracle like PERCENT_RANK,PERCENTILE_CONT,PERCENTILE_DESC etc..

Is there any plan to implement this in the coming releases.?

I have a requirement where I have to use this functions in HANA to migrate procedures from oracle.

Regards,

Venkat.

[lbreddemann]

Hi Venkat,

with SAP HANA you get this: SAP HANA Reference: Window Functions

Depending on your requirement, you may want to look into the business function library (BFL) as well (e.g. rolling average/sum).

- Lars