Showing results for 
Search instead for 
Did you mean: 

Availability of Oracle Analytical Functional in HANA

Former Member
0 Kudos

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.



Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

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